View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Can a For statement work in reverse (from 40 to 1)

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


--