View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.