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.