Viewing Formulas in Adjacent Cells

[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!

 

[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!

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.

 

[JE McGimpsey]

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.

You could use a UDF:


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

Usage:

B1: =GetFormula(A1)