resequence worksheet index after deletion of worksheet
 

dear all,
if i delete the worksheet, the index will run off. may i know how to
resequence besides doing in VBE properties?

thanks

resequence worksheet index after deletion of worksheet
 

What do you mean by "run off" and "resequence" ?

If you have code which is erroring, please post it.

If you're having problems looping through sheets and deleting them,
try moving in reverse order (last sheet first).

Tim.




"tango" wrote in message
om...
dear all,
if i delete the worksheet, the index will run off. may i know how to
resequence besides doing in VBE properties?

thanks

resequence worksheet index after deletion of worksheet
 

I think he means if he deletes Sheet2 and leaves Sheet1 & Sheet3, how can he
re-index what is left by making Sheet3 now Sheet2. Sort of like looping
through the Worksheet.Count and assigning a new Sheet index.

Mike F
"Tim Williams" <saxifrax@pacbell*dot*net wrote in message
...
What do you mean by "run off" and "resequence" ?

If you have code which is erroring, please post it.

If you're having problems looping through sheets and deleting them,
try moving in reverse order (last sheet first).

Tim.




"tango" wrote in message
om...
dear all,
if i delete the worksheet, the index will run off. may i know how to
resequence besides doing in VBE properties?

thanks