Excel Automatic Sheet Numbering

  • Thread starter Thread starter greasybob
  • Start date Start date
G

greasybob

When sheet number 2 is deleted, and then later added back in, Excel
numbers it as 3, even though number 2 is again available.
Is there a way to keep the sheets from auto-advancing, without
manually renaming them?
The auto advancing function is reaking havoc with my macros.
Thanks
 
Hi

you might be better off then using the index number to identify them in the
macros
e.g.
Sheets(1) is always the left most sheet in the workbook
Sheets(2) is immediately to the right of Sheets(1)

in this way, as long as you know the order in the workbook you don't need to
know their names

Hope this helps
Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet tab names change automatically 3
Is there a way to force out other editors when Excel 2003 is inautomation mode? 3
queries in excel 2
Automatic Page Number and Sheet Names? 2
Summarise data on multiple sheets 1
Autosort in Excel 2
all sheets need the same first 6 columns - user friendly presentat 1
automate adding sheets 6

Back
Top