| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Naming a newly inserted sheet using VBA
I want to insert a new sheet and name it "ABC":
Sheets.Add Sheets("Sheet1").Name = "ABC" This is fine for the first time as it inserts a new sheet called "Sheet1". However the next time I do it the newly inserted sheet is called "Sheet2", but the code is still looking for a "Sheet1". Can I do something simple like: Sheets.Add.Name = "ABC" Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get other sheet names into a column | Excel Worksheet Functions | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Copying Specific Values From Sheet | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
| Subset of one sheet on another sheet | Excel Worksheet Functions | |||
Threaded Mode
