View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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