The following code does not work in my Macro:
Code:
For Each MyCol In Array("F", "G", "H") Columns(MyCol).SpecialCells(xlCellTypeBlanks).EntireRow.Delete Shift:=xlUp Next MyCol</PRE>
Any thoughts? I'm using excel 2010, Win 7
<!-- / message --><!-- edit note -->
Code:
For Each MyCol In Array("F", "G", "H") Columns(MyCol).SpecialCells(xlCellTypeBlanks).EntireRow.Delete Shift:=xlUp Next MyCol</PRE>
Any thoughts? I'm using excel 2010, Win 7
<!-- / message --><!-- edit note -->