View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default macro to delete entire rows when column A is blank ...a quick macro

try this
Sub RowBeGone()
Columns("A").SpecialCells(xlCellTypeBlanks).Entire Row.Delete
End Sub

--
Don Guillett
SalesAid Software

"vikram " wrote in message
...
a macro which can quickly delete entire row when column A is blank

please help me with this
thank u so much frnds


---
Message posted from
http://www.ExcelForum.com/