Cells instead of range

[bobkap]

I would like to refer to cells with the Columns function but cannot figure out how to do it. Example: Rather than Columns("A:O").Select I'd prefer to use a variable so I can say Columns("A":lastcolumn") or something like that.

Maybe I should be asking how I can use variables with the Columns function?

 

[Rick Rothstein]

Thanks. Presumably, you could also use a variable instead of a column number or letter? Is that correct?

Yes...

Col = 5
Cells(2, Col)

also...

Col = "E"
Cells(2, Col)

Both version reference the same cell (E2).