For n=4 to lastrow Question

in any loops where you are deleting rows in your loop you need to count back

in the "if loop" to determine what row to delete
if condition is true and you actually delete a row you need to count back to N counter in order not to "skip" any rows

reason for this is
if n = 5 and it deletes the row
the below row which would have been 6 becomes 5
however n has incremented to 6
therefore you have effectively skipped a row

Hi Bruizer,

Humdingaling is correct in his thinking but might need some cleanup on his explanation.

If you read about a For.. Next Loop there is a third part that you need. It is the STEP part.

You should do a
For RowCtr = LastRow to 4 Step -1

This will start at the lastrow and delete those rows without encountering the problem you've discovered.

Look at http://www.databison.com/vba-for-loo...-each-in-next/ and the section that uses "Step".

yes sorry explanation was lacking

reverse loop!
genius

thanks marvin