Delete Rows Based on criteria

Good Afternoon,

The code below was working fine, but for some reason I am getting the below error now and are not sure what the deal is.

Run-Time Error '1004':
Cannot use that command for overlapping selections.

Goal: I am trying to search through Columns A,B,C,D and delete rows that contain the following items. Below is the code I have been using.

#N/A
#VALUE!
Blank Values
Rows that contain a cell with a single space
Rows that contain a Cell that contain the value 0 (0 by itself)
Rows that contain a Cell that contain $0.00

Please Login or Register  to view this content.

As always, any help is greatly appreciated.

You have 2 options:

Please Login or Register  to view this content.

Or
You need to put the entire range in the union so as to use the entrierow delete

try

Please Login or Register  to view this content.

Thanks Jindon - This worked perfectly. Really have been appreciating your help.

AB33 - Thank you as well.

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

matrix2280,

You can not ask any question via PM by the rule here.

Originally Posted by matrix2280

In this instance I need to run this code for Columns A,B (skip C) and then run the code again for Column D.

Chane to

Please Login or Register  to view this content.

Thanks again Jindon

Jindon,

For some reason (using the code above), I added a new value "#NAME?" and it will not remove it. Any ideas?

Try this one then

Please Login or Register  to view this content.

Jindon - It didn't remove it. I will add that when the code runs all of the data is set as text.

What is wierd is I can search for #NAME? and replace it with another value, and if i do the filter manually it finds it, but won't remove.

Can you upload a file?