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