View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terri Miller Terri Miller is offline
external usenet poster
 
Posts: 3
Default Delete Row if text or empty

I have been going through past posts, and they are very helpful. However,
most of them speak to deleting rows with specific data or numbers. I would
like to write a macro that delets all rows in which column A is empty or has
anything other than a date format i.e. dd/mm/yy. Some cells have the text
"DATE", some have "___", some are empty, etc.

Thanks