Thread: wrtie a macro to delete certain rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default wrtie a macro to delete certain rows
Hi mja

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

This can be very fast

Sub DeleteBlankRows_1()
'This macro delete all rows with a blank cell in column A
On Error Resume Next 'In case there are no blank cells
Columns("A").SpecialCells(xlCellTypeBlanks).Entire Row.Delete
On Error GoTo 0
End Sub

Warning Read this
http://www.rondebruin.nl/specialcells.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"mja" wrote in message ...
I would like to write a macro to delete rows if a cell in column b is blank.
Thanks in advance.


Reply With QuoteReply With Quote