View Single Post
  #2   Report Post  
Old November 17th 05, 02:41 PM posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Delete row based on contents of cell

One way is to use datafilterautofilter and record while doing it to
learn. Post back after you have tried this with addl questions.

--
Don Guillett
SalesAid Software

"AndyG" wrote in message
...
The following code does a great job of finding whole blank rows and
deleting
them:

Range("B1", Range("B65536").End(xlUp)).SpecialCells _
(xlCellTypeBlanks).EntireRow.Delete

However, could someone please tell me how to modify this for two other
purposes:

1) Delete the whole row if any cell in column A: is has the contents of
"SSN"

2) Delete the whole row if any cell in column C: is blank (null?)

Thank you in advance.