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