Display Formula in adjacent cell

**troy69** · 03-19-2009, 07:10 AM

G'day Everyone,

I need a little help. I want to display the formula in the adjacent box to where it is actually used. Would anyone happen to know how to get that done?

Example:

If cell A1 contains the following formula: A1+ A2
I want cell A2 to show : '= A1+A2'

Thank you in advance for your help. I appreciate it.

**DonkeyOte** · 03-19-2009, 07:34 AM

You would probably need a UDF, something like:

Please Login or Register  to view this content.

B1: =GETFORMULA(A1)

**troy69** · 03-19-2009, 08:45 AM

Donkeyote,

Thanks for the code but Excel returns an error when I try and use it. It says unrecognized name. Any ideas whats going on ?? Once again, thank you for your help. I appreciate it.

**DonkeyOte** · 03-19-2009, 08:47 AM

The Function must reside in a Module as opposed to a Sheet / Workbook Object. You will of course need to ensure you save your file as .xlsm type (or .xls) and when re-opening ensure Macros are enabled ... for more info on 2007 macro security see: http://office.microsoft.com/en-us/ex...969191033.aspx