Is there a way to select multiple columns in VBA using the column number?
I have this
But I would prefer to be able to select those columns using column numbers. It will not always be the same columns so using column numbers would be easier for me to code.
I have this
Code:
Range("D:E,G:H,J:K,M:N").Select
Selection.Delete Shift:=xlToLeft