Reducing the value of a loop counter

[danielexcelvba]

Hey everyone,
I've been trying to write a simple code that deleted every row with a blank cell in column "A", and I've attempted this using a For...Next loop as well as a Do Until loop (i'll post one example alone). I know I have to edit the value of "i" so that it changes if a row is deleted, but I keep getting into infinite loops and having to interrupt the code and I'm not sure why. Any ideas?

Please Login or Register  to view this content.

[danielexcelvba]

Oops figured it out right after posting
Had to decrease the value of the last row variable as well

Please Login or Register  to view this content.

[mehmetcik]

You need to start at the bottom and count down to 1

Please Login or Register  to view this content.

If you have a lot of rows then this will be extremely Slow.


You should avoid using loops.

Please Login or Register  to view this content.

[danielexcelvba]

Wow would never have thought of that thanks!