How to reverse order on FOR loop?
in [Programming]
|
Prev: Excel spreadsheet for weight and balance calc for Cessna 182
Next: change colors in a range of excel cells based on another range of cells
From: Eric on 8 Apr 2010 19:37 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
From: Rick Rothstein on 8 Apr 2010 19:43
Use the Step option... For I = 5 To 2 Step -1 -- Rick (MVP - Excel) "Eric" <Eric(a)discussions.microsoft.com> wrote in message news:B26C2EF1-1170-4181-867C-6F5E265C7AA8(a)microsoft.com... > 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 |