Update dynamic range in For...Loop?

[BigDelGooner]

Hi guys

I've simplified the code but having trouble with the following...

for c = 3 to Range("A65536").end(xlup).row
if cells(c,2).value = true then
rows(c).insert
end if
next

Basically because I am inserting row during the procedure the loop only remembers the initial last row rather than continually checking the range("A65536").end(xlup).row after each loop.

I have tried using a named range (i.e. End_Row) and incorporating this into the loop but this doesnt work either.

Any ideas?

 

[VoG]

Perhaps you missed my post http://www.mrexcel.com/forum/showpost.php?p=2428172&postcount=5

 

[BigDelGooner]

Beg your pardon, thanks VoG

 

[Ruddles]

Thjat's because the terminating value of a FOR...NEXT loop is evaluated once at the start whereas the terminating condition of a DO...LOOP is evaluated every loop.

Incidentally you can also modify the value of the control variable in a FOR...NEXT loop if you're careful.