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

Y

Youppie

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
 
F

Frank Kabel

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
 
Y

Youppie

Hi Frank,

thanks anyway...

Youppie

Frank Kabel said:
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
Click to expand...
 
Top