I see!
That means a formula type string can't be evaluated with built-in functions?

--
Thanx & Best Regards,

Faraz!


"Jacob Skaria" wrote:

Since you have '=' sign in your cell...

Function EquateFormula(strData As String) As Variant
EquateFormula = Application.EVALUATE(strData)
End Function

--
Jacob


"Faraz A. Qureshi" wrote:

I have a A1 with a formula ="+2+2"
I thought =INDIRECT(A1) would reflect 4 whereas it is returning #Ref!
How to carryout the desired function?
--
Thanx & Best Regards,

Faraz!