Hi Rob,

<I take the contents of the bracket and put it into a cell then Excel calculates the correct answer

The way one refers to cells in a worksheet differs from how it's done in VBA.
What's your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rob" wrote in message ...
|I have a UDF which uses EVALUATE ( )
|
| If I take the contents of the bracket and put it into a cell then Excel
| calculates the correct answer, but I get zero from Evaluate.
|
| The contents of the bracket is a SUMPRODUCT formula.
|
|