Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating & Naming a New Worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating & Naming a New Worksheet
sub ad()
worksheets.add Activesheet.Name = "Changes" End Sub or Sub Addsheet() worksheets.Add.Name = "Changes" End sub -- Regards, Tom Ogilvy "teresa" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Help for naming a worksheet tab | Excel Discussion (Misc queries) | |||
Worksheet naming | Excel Discussion (Misc queries) | |||
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
Naming Worksheet | New Users to Excel | |||
Naming a worksheet help? | Excel Worksheet Functions |