Archive of Mr Excel Message Board Back to General Excel archive
index Back to archive home Display formula in a cellPosted by
Rich Allwes on January 08, 2002 9:05 AM Is there an existing
macro or formula for displaying the formula contained in a cell
in another cell. For example: The number 25 is displaced in cell
A3. I want to list the formula "=3*gamma-beta of cell A3 in cell
B3. Gamma and beta are range names of cells. I would appreciate
help in this matter. Re: Display formula in a cellPosted by Andy
Gee on January 08, 2002 9:25 AM Why not just type it then format
it as text! Re: Display formula in a cellPosted by Dat on
January 08, 2002 10:15 AM Push---- Ctrl + ~ at the same time (~
is under the Esc key) Re: Display formula in a cellPosted by
Chris D on January 08, 2002 10:31 AM Would you want the
displayed formula to change if you changed the original formula,
without having to do any typing or anything ? If you do, I have
a very cumbersome non-macro fix which I'm sure can be put to
shame by the VBA guy