Mat
Well-known Member
- Joined
- Sep 17, 2003
- Messages
- 509
Hi,
I'm pretty sure there's a way to do this in VBA.
I would like to show the evaluated formula (with the numbers, not the cell reference) in a cell, based on another cell formula.
Let say I have :
A2 = 3
B3 = 4
D3 = 5
A1 = "=A2+B3*D3"
Then B2 = "=EvaluatedFormula(A1") would display : "=2+4*5"
So I need a routine that will replace the addresses by their actual value in a formula.
B2 = "=SUBSTITUTEADDRESSBYVALUE(FORMLATEXT(B2))
Thank you
Mathieu
I'm pretty sure there's a way to do this in VBA.
I would like to show the evaluated formula (with the numbers, not the cell reference) in a cell, based on another cell formula.
Let say I have :
A2 = 3
B3 = 4
D3 = 5
A1 = "=A2+B3*D3"
Then B2 = "=EvaluatedFormula(A1") would display : "=2+4*5"
So I need a routine that will replace the addresses by their actual value in a formula.
B2 = "=SUBSTITUTEADDRESSBYVALUE(FORMLATEXT(B2))
Thank you
Mathieu