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" <Confused@discussions.microsoft.com> wrote in message
news:5EFBD56F-9CE6-40AD-A191-576BB9AB41C1@microsoft.com...
> 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.