last row needs updating

[robertvdb]

I have a range of, say, 10 rows which needs to be looped through.

If a certain condition is met, then a new row needs to be inserted, making the range = 11 rows.

So zRow (the last row) increases from 10 to 11.

However, zRow stays at 10. Any idea how to solve this ?

 

[FormR]

Hi, generally speaking, if you are inserting or deleting rows with VBA in a loop then you should start from the bottom and work up.

For zRow = 10 To 2 Step -1
'do stuff
Next zRow

 

[robertvdb]

Thanks FormR

your advice is very useful, yet it does not solve the issue of the zRow number which has changed. Any further suggestions on this issue ?

Thanks

 

[FormR]

Hi, you haven't provided enough information for me to comment further.

 

[robertvdb]

OK, I think I'm gonna close this post, since your advice to work decrementally solves my issue. Thanks.