#1
|
|||
|
|||
New Sheet naming
I am trying to record a macro that deletes a sheet and creates a new one.
The problem is that excel renames sheets.. if I create a new one the first time, it calls it sheet1; if I delete it and create a new one again, it calls it sheet2. This really messes up the macro, and it mis-references the sheet because the name has changed. I can't even rename the sheet, because it can't find the original sheet1. Is there any way around this? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Batch re-naming | twols26 | Word VBA | 7 | 06-16-2015 12:29 PM |
Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
Naming Cells for formula referencing | lynchbro | Excel | 6 | 06-26-2014 07:45 AM |
re-naming arrays in VBA? | JDevsFan | Excel Programming | 4 | 03-15-2012 08:44 AM |
Auto file naming | Rong Peng | Word VBA | 0 | 07-29-2011 07:37 AM |