Sunday, February 8, 2015

VBA Code to Delete Multiple Columns in MS Excel

Use Below VBA Code to Delete Multiple Columns in MS Excel from your active worksheet
Sub DeleteColumns()

'Delete the Column B and D in the active worksheet

    Columns("B:B, D:D").Select 

    Selection.Delete Shift:=xlToLeft

End Sub


No comments:

Post a Comment