copy a link from one col to another via a formula

[Confused]

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)


--
Regards,
Tom Ogilvy

"Confused" <[email protected]> wrote in message
news:[email protected]...
> 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.