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

--
Message posted from http://www.ExcelForum.com

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



--
Message posted from http://www.ExcelForum.com

Hi
use
Cells(600,activecell.column)

--
Regards
Frank Kabel
Frankfurt, Germany


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!

Cheers


---
Message posted from http://www.ExcelForum.com/

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?

--
Message posted from http://www.ExcelForum.com

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)


--
Regards
Frank Kabel
Frankfurt, Germany


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

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


---
Message posted from http://www.ExcelForum.com/

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

Cheers again

--
Message posted from http://www.ExcelForum.com