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