Hi
try
activecell.value=cells(activecell.row,1).value

--
Regards
Frank Kabel
Frankfurt, Germany

"Kelvin Clayson" schrieb im Newsbeitrag
...
Hi all -

Can anyone clue me in as to how I could get the value of a cell in
column A
to the active cell? E.g. if the active cell is C116, how can I read
the
value in A116?

I've tried using the Offset property, but this seems to require the
exact
number of columns, whereas the active cell could be in any row.

Many thanks for all/any help - I'm almost there with this!!

Cheers


Kelvin