how to get the formula shown in linked cell's names

[=?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=]

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

 

[Tom Ogilvy]

ActiveCell.Name.RefersTo

or just
ActiveCell.Name

 

[Guest]

Hi

is Ctrl + `

works for you?

` is the key next to 1 on the keyboard.

 

[=?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=]

THANKS AGAIN.

but maybe my misunderstanding,

it dosent work well.

Regards

 

[Guest]

Thanks .
i got it.

thanks

Hi

is Ctrl + `

works for you?

` is the key next to 1 on the keyboard.

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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.