Thread: delete rows with empty cells throughout the data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rutski rutski is offline
external usenet poster
  
Posts: 3
Default delete rows with empty cells throughout the data
On Nov 16, 10:22 am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
gr,

Range("A1:I400").SpecialCells(xlCellTypeBlanks).En tireRow.Delete

HTH,
Bernie
MS Excel MVP

"rutski" wrote in message

...

How would i delete the rows of data if any of the cells are empty for
say a range a1 to i400?

thanks,

gr

thanks Bernie
Reply With QuoteReply With Quote