Delete empty rows

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

Is there a simple macro that will delete all the rows in a selection
that do not contain any data?

Likewise, is there something similar regarding columns?

Many thanks in advance
 
Ian,

Try something like
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top