Select a range by column number

[David Andrews]

I need to select a range of cells knowing only the column index number (i)
So Range("C2:C12") needs to be Range("i2:i12").

I know there is the Cells command:
like Cells(5, i).Select
but this only selects one cell. I guess its a syntax problem for me.

Ideally i need to select a range with variable for row and column..any tips
?

 

[Don Guillett]

range(cells(2,i),cells(12,i)).select

However, you usually do NOT need to select to do what is needed and it is
better NOT to select.

 

[Bob Phillips]

Cells(2, i).Resize(11).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)