...e_006...


Delete empty cells in selection
Sub Del_empty()
   Selection.SpecialCells(xlCellTypeBlanks).Delete _
   Shift:=xlUp
End Sub

by Monika Weber