Macro- Delete rows

March 10, 2009 at 11:13:35
Specs: Windows Vista
I want to keep the following rows there if anything below is in one the the columns listed:

A,B,C,D, E, H & I: any #'s between 1-300
F: any "C's" or "I's"

If it has a zero or blank in all columns A-I it can be deleted.

Hope that makes more sense.

See More: Macro- Delete rows

Report •

March 11, 2009 at 10:59:57
re: If it has a zero or blank in all columns A-I it can be deleted

Does the code have to check for numbers like 500 in the specified columns or other letters in F?

If the values will only be 0 to 300 or C or I then all we are really checking for is blanks or zeros.

However, if a cell might contain 536 or Q, then we have to be very specific about what we search for before deleting a row.

Let us know.

Report •

March 11, 2009 at 15:23:46
I was able to figure out the code I needed for this, however I'm trying now to find out the following:

I've creating a drop down that has different words, once I select from the drop down my cell is white (before selecting I've saved it as red).

Any way to make drop downs a colour?

Report •

March 11, 2009 at 20:02:58
You should probably post that question in a new thread under an appropriate subject line.

P.S. When you do, please include more detail because I wasn't able recreate the problem with a simple Data Validation Dropdown list.

Report •

Related Solutions

Ask Question