Viewing Formulas in Adjacent Cells

M

Michael

Is there a way to have the full formula "appear" in an adjacent cell? I
want to show my work on the hard copy of a test.

Thanks!
 
P

Paul Berkowitz

Is there a way to have the full formula "appear" in an adjacent cell? I
want to show my work on the hard copy of a test.

Thanks!
Click to expand...

If you re-type the formula there, preceded by an apostrophe ('), it will
display the formula rather than the result. This could also be done by macro
if you have many different formulae and don't want to type them all out
again.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
J

JE McGimpsey

Michael said:
Is there a way to have the full formula "appear" in an adjacent cell? I
want to show my work on the hard copy of a test.
Click to expand...

You could use a UDF:


Public Function GetFormula(ByRef cell As Range) As String
GetFormula = cell(1).Formula
End Function

Usage:

B1: =GetFormula(A1)
 
Top