How do I display a formula - not the value - in another cell?

[Guest]

Hi gurus,

maybe this is a completely stupid question and I am blind to the obvious,
but how can I display the formula in one cell as text in another cell?
For example:
A1 = 1
A2 = 2
A3 = "=A1+A2"
A4 should show "A1+A2" (I know how to get rid of the "="...)
And I know how to do this in VBA, but I would love to be able to avoid
macros...

Best regards and thanks in advance
Youppie

 

[Guest]

Hi
AFAIK not possible with macros (you could use XLM macros as defined names
but they could crash excel in versions prior to Excel 2003).
So without vBA IMHO no solution

 

[Guest]

Hi Frank,

thanks anyway...

Youppie

Hi
AFAIK not possible with macros (you could use XLM macros as defined names
but they could crash excel in versions prior to Excel 2003).
So without vBA IMHO no solution