Column

M

mushy_peas

if i use

DIM Colset
Colset = ActiveCell.Column

and say the active cell is G10, then Colset will be G

how do i use Colset to select another cell, something like:-
Range("Colset" & 600).Select

but it didnt work

any1 know why!

Cheer
 
K

kkknie

ActiveCell.Column returns a number. You would need to use anothe
method to select based on it.

Colset = ActiveCell.Column

Cells(600,Colset).Select

Or even better

Cells(600,ActiveCell.Column).Select

BTW, using Range("Colset" & 600).Select would show up in excel a
Range(Colset600).Select. If you wanted to concatenate the colum
number it would b Range(Colset & 600).Select (which still wouldn't wor
in our case). You can however do this with a row:

Range("G" & ActiveCell.Row).Select
 
M

mushy_peas

thanks for the speedy replies
But i tried
Cells(600,Colset).Select

it didnt work. im confused, normally its G600, so why is it no
600colset or 600G?
 
F

Frank Kabel

Hi
should do (works for me) if colSet is the column NUMBER of column G
(that is 7)

for your other question: Cells has the syntax
cells(row_index,column_index)
 
M

mushy_peas

Cool, thanks loads. Got it working.
Got another question, but i'll do it in another post.

Cheers again
 
Top