PC Review


Reply
Thread Tools Rate Thread

How can I create a worksheet using Macro

 
 
=?Utf-8?B?S3Jpc2huYW4=?=
Guest
Posts: n/a
 
      21st Feb 2006
I am a beginner; I need to generate a new worksheet and rename the new work
sheet; Please help me out in this
 
Reply With Quote
 
 
 
 
Norman Jones
Guest
Posts: n/a
 
      21st Feb 2006
Hi Krishnan,

Try:

'=============>>
Public Sub Tester003()
ActiveWorkbook.Sheets.Add.Name = "Krishnan"
End Sub
'<<=============


---
Regards,
Norman


"Krishnan" <(E-Mail Removed)> wrote in message
news:B9444E28-8213-45ED-9F39-(E-Mail Removed)...
>I am a beginner; I need to generate a new worksheet and rename the new work
> sheet; Please help me out in this



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a macro to create a report on another worksheet =?Utf-8?B?QlpleWdlcg==?= Microsoft Excel Programming 1 13th Apr 2007 07:54 PM
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error acctemp@millenniumbank.com Microsoft Excel Misc 4 25th Sep 2006 01:35 PM
How can I create/add a worksheet using Macro =?Utf-8?B?S3Jpc2huYW4=?= Microsoft Excel Programming 1 21st Feb 2006 08:08 AM
How can I create a worksheet using Macro =?Utf-8?B?S3Jpc2huYW4=?= Microsoft Excel Programming 1 21st Feb 2006 07:19 AM
Use a macro to create a new list using another worksheet ineedhelp2 Microsoft Excel Programming 1 18th Aug 2005 06:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:43 PM.