ActiveCell.Name.RefersTo

or just
ActiveCell.Name

--
Regards,
Tom Ogilvy


"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i want get the formula as a text shown in the linked cell's names instead
of
the linked cell's addresses,

maybe Apllynames can do it ,but it cannot return the formula to be shown
in
the linked cell's addresses.

i just only want to get the formula a text shown in the linked cell's
names
, not to want the cell is really shown in the linked cell's names .

thanks