Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a new sheet.
I am adding a new sheet and trying to name that sheet.
I can add a sheet and i can name a sheet using vba But when i try to do them together it doesn't work. I can add a sheet. Then i have to fugure out what it is named and then i can change the name. Is there a simplier way to add a new sheet to a workbook and change the name? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a new sheet.
One way:
ThisWorkbook.Worksheets.Add.Name = "myname" In article , "Rich Cooper" wrote: I am adding a new sheet and trying to name that sheet. I can add a sheet and i can name a sheet using vba But when i try to do them together it doesn't work. I can add a sheet. Then i have to fugure out what it is named and then i can change the name. Is there a simplier way to add a new sheet to a workbook and change the name? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
naming a sheet the same as a cell in that sheet | Excel Discussion (Misc queries) | |||
Naming a sheet | Excel Discussion (Misc queries) | |||
naming sheet tab | Excel Worksheet Functions | |||
Naming Sheet | Excel Discussion (Misc queries) | |||
Automatic sheet naming | Excel Programming |