reset the range of FOR loop

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

 

[Gary''s Student]

"for"get FOR. Use While:

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