Add (sum) numbers within cells
He may have been thinking of the Morefunc add-in function EVAL().
--
Biff
Microsoft Excel MVP
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
None that I know of.
Perhaps Mike meant to use a UDF like this.
Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function
=EvalCell(A1) where A1 contains 1+5+8
Gord Dibben MS Excel MVP
On Tue, 20 Oct 2009 17:03:41 -0400, "T. Valko"
wrote:
=EVAL(A1)
I don't think there's a native EVAL worksheet function in Excel 2007.
|