For Loop exiting early

[Chopper50]

I have For/ Next loop where I use i=2 to Lastrow. In the loop I insert rows and increment the Lastrow variable to account for the additional row I inserted.

It appears the the program only evaluates the For statement against the original Lastrow value. Is this the case? Is there anything to be done that would allow the Lastrow variable to be incremented and used?

I've seen where the suggestion is to start from the bottom and decrement the i value. Is this the only way?

Chad

 

[Fluff]

I've seen where the suggestion is to start from the bottom and decrement the i value. Is this the only way?

Whilst it's not the only way, it is strongly recommended that you take this approach.

 

[Rick Rothstein]

It appears the the program only evaluates the For statement against the original Lastrow value. Is this the case?

Yes... the limits for a For..Next loop are only evaluated once at the time the loop starts and are retained until the loop ends.

Is there anything to be done that would allow the Lastrow variable to be incremented and used?

Use a Do..Loop and handle incrementing the variable manually within it.

I've seen where the suggestion is to start from the bottom and decrement the i value. Is this the only way?

As Fluff said, it is the recommended method as it is the simplest way to do this.

 

[Chopper50]

Thank you both. I got the code corrected for the bottom up. Works well.

 

[Fluff]

Glad you sorted it & thanks for the feedback