ExcelBanter - How to reverse order on FOR loop?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to reverse order on FOR loop? (https://www.excelbanter.com/excel-programming/441465-how-reverse-order-loop.html)

Eric

How to reverse order on FOR loop?

Does anyone have any suggestions on how to reverse the order on FOR loop?
For i = 2 To 5 is starting from 2 to 5, but I would like to start from 5 to 2.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Rick Rothstein

How to reverse order on FOR loop?

Use the Step option...

For I = 5 To 2 Step -1

--
Rick (MVP - Excel)

"Eric" wrote in message
...
Does anyone have any suggestions on how to reverse the order on FOR loop?
For i = 2 To 5 is starting from 2 to 5, but I would like to start from 5
to 2.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

All times are GMT +1. The time now is 03:05 AM.