If...and...then row delete

[Hellkeeper]

Hello there!

What I want the code to do is quite simple: Go through each cell of a column and delete every row that is not equal to two variables. It should start at row 2 and stop at the first emtpy cell.

Now I have actually found an alternative to my code that works somewhere else but I would still like to know why mine won't work. It does work perfectly if I'm not using the "<>" operator but not using it isn't practical for my purposes. At the moment what it does is, it's deleting every 2nd row disregarding the content in the specified cell/column.
So here's the code:

Please Login or Register  to view this content.

Thank you very much =)

[xladept]

If you delete a row then you musn't increment the index

Do this instead:

Please Login or Register  to view this content.

[Hellkeeper]

Aww, great, debugging for the win :D Should've thought of that myself...anyways, thank you very much for your time and knowledge!

[xladept]

You're welcome!