Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating worksheets then name it
I am attempting to create a new worksheet in a macro and
give it a specified name. I can create the worksheet with the following command: ActiveWorkbook.Sheets.Add After:=Worksheets("test") What I can't figure out is how to name the newly created worksheet. Anyone have an idea on how to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating 2 new Worksheets | Excel Discussion (Misc queries) | |||
Creating new worksheets | Excel Worksheet Functions | |||
creating sub worksheets | Excel Worksheet Functions | |||
Creating worksheets | New Users to Excel | |||
Creating old xls worksheets. | Excel Discussion (Misc queries) |