Excel Automatic Sheet Numbering

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
 
J

JulieD

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
 
Top