Delete empty rows

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
 
C

Chip Pearson

Ian,

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


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