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