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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> ActiveCell.Name.RefersTo
>
> or just
> ActiveCell.Name
>
> --
> Regards,
> Tom Ogilvy
>
>
> "EXCEL$B!!(BNEWS" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> THANKS AGAIN.
>
> but maybe my misunderstanding,
>
> it dosent work well.
>
> Regards
>
>
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:[email protected]...
> > ActiveCell.Name.RefersTo
> >
> > or just
> > ActiveCell.Name
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "EXCEL$B!!(BNEWS" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> Thanks .
> i got it.
>
> thanks
>
>
> "Leung" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> > >
> > >
> > >
>