condition based deletion - using loop

Forget the code for a moment, can you tell us:

1) what your condition for deletion is?
2) what column your checking?
3) where in the column you are starting (looks like row 2)
4) what determines when to stop (empty cell in that column?)
5) is there additional data in that column further down or does the last cell with data in that column tend to represent the bottom of the data on that sheet?

Or, just give this alternate version a try:

Please Login or Register  to view this content.

See, it always pays to start with a worksheet. The question is: "Are you always filtering by a numeric string?"

The culprit is this line of code:

Please Login or Register  to view this content.

..which I used directly from your original formula. TYPE 2 is "string" or text. The number "2" as a filter criteria isn't accurate enough.

Change that to TYPE:=1 for "numeric" and it works fine FOR NUMBERS only.

If you want a permanent solution that works for anything (numerics or text strings as a filter), then use BOTH like so:

Please Login or Register  to view this content.

This will spot numbers as numbers and only match to numbers, spot text strings as text and treat them likewise.