Column

[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

 

[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

 

[Frank Kabel]

Hi
use
Cells(600,activecell.column)

 

[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?

 

[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)

 

[mushy_peas]

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

Cheers again