Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to use a For statement in reverse?
For example: For i = Sheets.Count To 4 Sheets(i).Activate Next i Instead of starting at sheet 4 and working up to the number of sheets in the workbook, I'd like to start on the last sheet of the workbook and work back to sheet 4. Is this possible? The reason I want to do this is because based on certain criteria, I may be deleting that sheet. Once that happens the sheet numbers get thrown off and I end up missing some sheets and then possibly getting an error near the end of the code when it tries to view sheets that don't exist. Thanks in advance. Paul -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help - If statement will not work | Excel Worksheet Functions | |||
if then statement... can't make it work:S | Excel Discussion (Misc queries) | |||
I can not seem to get my IF / AND statement to work, help please | Excel Discussion (Misc queries) | |||
Why doesn't this nested IF statement work? | Excel Worksheet Functions | |||
This statement does not work in VB | Excel Programming |