hi,
found some macro's @ this website but they arent exactly what i need.
Sub DeleteBlanks()
Range("A9:M9").SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
End Sub
i need a macro thats able to empty a column(lets say colum d) but not the first lets say 2 cels. The rest of the cels(cell 3 and more) should be emptied.
thanks in advance
found some macro's @ this website but they arent exactly what i need.
Sub DeleteBlanks()
Range("A9:M9").SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
End Sub
i need a macro thats able to empty a column(lets say colum d) but not the first lets say 2 cels. The rest of the cels(cell 3 and more) should be emptied.
thanks in advance