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

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

Hi

is Ctrl + `

works for you?

` is the key next to 1 on the keyboard.




"EXCEL　NEWS" wrote:

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

THANKS AGAIN.

but maybe my misunderstanding,

it dosent work well.

Regards



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

Thanks .
i got it.

thanks


"Leung" wrote in message
...
Hi

is Ctrl + `

works for you?

` is the key next to 1 on the keyboard.




"EXCEL　NEWS" wrote:

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

Well your question was not very clear. Maybe you want to try again. My
answer was a guess at what you were asking.

--
Regards,
Tom Ogilvy



"EXCEL$B!!(BNEWS" wrote in message
...
THANKS AGAIN.

but maybe my misunderstanding,

it dosent work well.

Regards



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

so you want to toggle between viewing formulas and viewing the results of
those formulas. (a little clearer, no? )


in addition to the shortcut combination, Tools=Options=view tab, select or
unselect formulas under windows options.
--
Regards,
Tom Ogilvy


"EXCEL?NEWS" wrote in message
...
Thanks .
i got it.

thanks


"Leung" wrote in message
...
Hi

is Ctrl + `

works for you?

` is the key next to 1 on the keyboard.




"EXCEL?NEWS" wrote:

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