Thread
:
Deleting A COLUMN BY MACRO
View Single Post
#
7
Posted to microsoft.public.excel.newusers
Cimjet[_4_]
external usenet poster
Posts: 29
Deleting A COLUMN BY MACRO
I wish we could edit are post but anyway, here is a one line that will do the same.
Sub DeleteColumn()
Range("A:A,C:C,E:E,H:H").Delete Shift:=xlToLeft
End Sub
Don't need to select the columns
Cimjet
Reply With Quote
Cimjet[_4_]
View Public Profile
Find all posts by Cimjet[_4_]