Creat a new worksheet

  • Thread starter Thread starter lashio
  • Start date Start date
L

lashio

Please help me to write a VBA code to creat a new worksheet named "New"
Thanks
 
Hi lashio

ActiveWorkbook.Sheets.Add.Name = "New"

--

XL2003
Regards

William
(e-mail address removed)
 
Please help me to write a VBA code to creat a new worksheet named "New"
Thanks
Click to expand...

Sub CreateNewWks()

Dim wks As Worksheet

Set wks = ActiveWorkbook.Worksheets.Add

'WARNING!
'This will fail if there's already a sheet by that name.
wks.Name = "New"

Set wks = Nothing

End Sub
 
Thank you, Hank

Hank Scorpio said:
Sub CreateNewWks()

Dim wks As Worksheet

Set wks = ActiveWorkbook.Worksheets.Add

'WARNING!
'This will fail if there's already a sheet by that name.
wks.Name = "New"

Set wks = Nothing

End Sub
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to insert new worksheet based on # of rows in a data sourch 2
Excel VBA 0
Create a new worksheet with a macro and giving it a specific name 4
Add standard header and footer to new worksheet 2
Need Macro to create a new worksheet and insert image 3
Macro to create validation list of worksheet names 1
Excel VBA - Problem with Closing Print Preview 0

Back
Top