Thread: Delete all rows where column A is blank
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Delete all rows where column A is blank
Warning: Look out with SpecialCells

See
http://www.rondebruin.nl/specialcells.htm




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Homey" <noname wrote in message ...
Try this

Range("A:A").SpecialCells(xlCellTypeBlanks).Entire Row.Delete

"Jodie" wrote in message
...
I need to write a macro to delete all rows where column A is blank. Can
anyone help me with this please?
--
Thank you, Jodie

Reply With QuoteReply With Quote