copy a link from one col to another via a formula

[Guest]

I have 25 worksheets in 1 book, 24 are accounts and 1 summary(sorted) with
links back to the accounts. I need to be able to retrieve the account link
and be able to post back to the account data from the summary. Can this be
done.

 

[Tom Ogilvy]

If it is like

=sheet1!A1

you can do

sform = ActiveCell.Formula
set rng = Range(mid(sForm,2))
msgbox rng.Address(external:=True)