Works fine for me Jim.

Does the range A1:A3 have anything odd i it?
Does A4 sum to the correct value?

"Jim May" wrote in message news:LYi0f.67$jw6.44@lakeread02...
With the following in a standard module:

Function IsFormula(cell As Range) As Boolean
IsFormula = cell.HasFormula
End Function

In cell A4 of sheet1 there is a formula = Sum(A1:A3)
In cell B4 I have =IsFormula(A4) -- Displaying #Value?

I've search google, etc..
CRAP!!