Can a For statement work in reverse (from 40 to 1)

[PCLIVE]

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


--

 

[John Bundy]

For i = 4 To Sheets.Count step-1

 

[PCLIVE]

Thanks John. That's good to know for future use. However, I ended up using
a DoWhile loop and subtracting 1 each time. The outcome is the same, but
I'm sure using "step-1" would look better. I may end up reworking my code
with this.

Thanks again.
Paul

--