Thread: Delete all rows where column A is blank
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Delete all rows where column A is blank
Do you really need a macro?

Select column A

F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP


On Thu, 10 Dec 2009 13:59:01 -0800, Jodie
wrote:

I need to write a macro to delete all rows where column A is blank. Can
anyone help me with this please?

Reply With QuoteReply With Quote