Creating & Naming a New Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All I want to do is create and name a new Worksheet,
The below code doesn't quite work, your help would me much appreciated:

sub ad()

worksheets.add
Set worksheets.Name = "Changes"

End Sub
 
sub ad()

worksheets.add
Activesheet.Name = "Changes"

End Sub

or

Sub Addsheet()
worksheets.Add.Name = "Changes"
End sub
 

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

Naming work sheet the name as sub-routine that creates it 4
Delete sheets code error requires object 2
Adding a worksheet within the workbook at specific position 1
Excel crashes and restarts when accessing newly created worksheet 2
rename the new worksheet 5
Copying a formatted "template" sheet and naming new sheet via user form 1
Pivot Table..getting a list of all, sourec odata and sheets locate 4
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top