Select a range by column number
 

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
?

Select a range by column number
 

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.


--
Don Guillett
SalesAid Software

"David Andrews" wrote in message
news:_8yai.167$%M5.6@trndny02...
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
?

Select a range by column number
 

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

--
HTH

Bob

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

"David Andrews" wrote in message
news:_8yai.167$%M5.6@trndny02...
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
?