Range("A" & (ActiveCell.Row)).Copy translated in formula

[littlepete]

Google is not helping me : i'm looking to copy the value of column Ax and any row (1~400) to another cell...
always i'm getting =Range("Ax" & (ActiveCell.Row)).value but that's for vba i need the translation into a formula...

I hope your last day of the year is fun !!!

 

[littlepete]

hello all

i found a solution to make it easy to make the cell of father and mother clickable ...
as you can see on the picture only the columns a to f are visible, representing in decent language all the
data filled in in columns k to ck ...

solution:
when mom or dad have a link (in columns ax or ay) the word link is put in column D.
when i see that i can click on cell A2 that starts a macro : it hides columns C to AW putting the column
with the links of mom and dad right next to the name of the person ...
the macro works both ways: if columns are hidden, it makes all visible too.

so glad there is a solution for this ! thank you all for the help !!!