Thread: Easy Question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Posse John Posse John is offline
external usenet poster
  
Posts: 9
Default Easy Question
Thank you both...didn't know about the 'specialcells' function. NICE.

Ended up using:
Columns("A:A").SpecialCells(xlCellTypeBlanks).Enti reRow.Delete

Reply With QuoteReply With Quote