reset the range of FOR loop

  • Thread starter Thread starter Farooq Sheri
  • Start date Start date
F

Farooq Sheri

I have the following bit of code in my macro.

For colCnt = 2 To lstCol

(lines of code here)

Next colCnt

Within the For loop certain conditions require changing the value of lstCol
(say it was 5 initially and it becomes 6). Is there a way to ensure that loop
executes till colCnt = 6 (inclusive). I tried setting lstCol = 6 but the loop
excutes only uptil 5.

Thanks for your help.
 
"for"get FOR. Use While:

Sub loopy()
topp = 5
i = 1
While i < topp
MsgBox (i)
topp = 8
i = i + 1
Wend
End Sub
 
Back
Top