resequence worksheet index after deletion of worksheet

T

tango

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

thanks
 
T

Tim Williams

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.
 
M

Mike Fogleman

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
 

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

resequence my worksheets 1
Automatic indexing in footnotes - solved 0
how to protect from insert, delete, resequence worksheet in workbook 1
Resequence figure numbers 3
Remove Numbering but not resequence 1
Insert Index into a Table 1
Run macro on all files in a specific folder 3
Sorting worksheets by name AND colour 6

Top