referring to columns by number

[Stefi]

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

 

[Bob Phillips]

Columns(colNoFrom).Resize(, ColNoTo - ColNoFrom + 1).Delete Shift:=xlToLeft

 

[Stefi]

Thanks Bob, I didn't think that it can be solved so tricky!
Stefi


„Bob Phillips†ezt írta: