Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Tab index | Excel Discussion (Misc queries) | |||
Allowing row deletion in worksheet with locked cells | Excel Discussion (Misc queries) | |||
protect worksheet but allow row deletion | Excel Worksheet Functions | |||
Protect worksheet from deletion | Excel Discussion (Misc queries) | |||
how to protect from insert, delete, resequence worksheet in workbook | Excel Programming |