Thread: Deleting rows based upon the value in column D
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ackurv[_3_] ackurv[_3_] is offline
external usenet poster
  
Posts: 1
Default Deleting rows based upon the value in column D

very nice, I was able to consolidate the following three lines
recorded, into one.

Columns("B:B").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete

Thanks, To

--
ackur
-----------------------------------------------------------------------
ackurv's Profile: http://www.excelforum.com/member.php...fo&userid=1552
View this thread: http://www.excelforum.com/showthread.php?threadid=27204

Reply With QuoteReply With Quote