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


--

For i = 4 To Sheets.Count step-1

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"PCLIVE" wrote:

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

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

--

"John Bundy" <(E-Mail Removed)(remove)> wrote in message
news:5FCEB1A5-06F0-4A40-B62C-(E-Mail Removed)...
> For i = 4 To Sheets.Count step-1
>
> --
> -John
> Please rate when your question is answered to help us and others know what
> is helpful.
>
>
> "PCLIVE" wrote:
>
>> 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
>>
>>
>> --
>>
>>
>>
>>