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
?