Excel, How Can you Show what Formula is in another Cell? 2

[Randy11]

Want to set up a cell next to a cell with a formula in it & have the formula show in the second cell. Needs to be set up that if the original formula is changed so would the 2nd cell. See below.

Cell B1 Formula Result Sample of Result Wanted in Cell B2
1 =SUM(Sheet2!E16:E19)
This is the formula in B1

 

[Zathras]

AFAIK the only way to do this is with a User Defined Function (UDF).

Put this in a code module:
[blue]

Option Explicit

Function ShowFormula(Ref As Range) As String
  ShowFormula = Ref.Formula
End Function

[/color]
Then put this in the worksheet:
[blue]

B1: =SUM(Sheet2!E16:E19)
B2: =ShowFormula(B1)

[/color]

 

[Randy11]

Excellent Solution, Worked like a charm, Thanks!