Hi All,

I can refer to one column with its number like this:

colNo = 2
Columns(colNo).Delete Shift:=xlToLeft

How can I refer to more than one columns without converting column numbers
to column letters, something like this:

colNoFrom = 2
colNoTo = 5
Columns(colNoFrom:colNoTo).Delete Shift:=xlToLeft

Thanks,
Stefi