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" wrote in message
...
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.