Thread: delete rows with empty cells throughout the data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default delete rows with empty cells throughout the data
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



Reply With QuoteReply With Quote