Code deletes every other row but should delete every row

[kelseygueldalewis]

I have code that is supposed to delete every row that contains a O in column T, but it is deleting every other row that contains a 0 in column T.

Here is the code

Please Login or Register  to view this content.

i = 2 because the first row has headers and because I was getting a data type mismatch error.

Any suggestions?

[CK76]

You should step backward, since deleting row readjusts row index.

Please Login or Register  to view this content.

Edit: alternately you can loop to only increase count when row isn't deleted.

[kelseygueldalewis]

Of course! Thank you CK76!

A followup Q - why is it better to use Rows(i)EntireRow.Delete instead of Rows(i).Delete?

[CK76]

Not much. EntireRow just allows you to use other range. Such as Cells, Range etc.

Just force of habit that I used it