Delete rows missing contents in AF then A

**EJensen** · 07-23-2009, 12:47 PM

Good day to you. here is what I am working on. If a row in Column AF does not say “Cust” than I want to delete it, next if a row in Column A does not say “Numb” I want to delete it. Here is what I am working with so far. If you can assist, thank you.

Please Login or Register  to view this content.

**karan** · 07-23-2009, 01:03 PM

Hi Ejensen,

Try this:

Please Login or Register  to view this content.

**EJensen** · 07-23-2009, 02:34 PM

Sorry I should have been more specific the rows do have other contents in them. Just not Cust or Numb, when that happens (the rows are missing Cust or Numb but have other contents in them) I want to delete the rows. If I was talking about blank rows though, this works awesome. Any thoughts? sorry for any confusion.

**karan** · 07-24-2009, 01:23 AM

The code which I posted deletes all those rows that have any other value other than 'Cust' in Column AF and 'Numb' in Column A. It deletes all other values as well as blanks.

I hope I have interpreted you correctly.. If not, please elaborate..

Regards,
Karan