referring to columns by number
Thanks Bob, I didn't think that it can be solved so tricky!
Stefi
€˛Bob Phillips€¯ ezt Ć*rta:
Columns(colNoFrom).Resize(, ColNoTo - ColNoFrom + 1).Delete Shift:=xlToLeft
--
__________________________________
HTH
Bob
"Stefi" wrote in message
...
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
|