Posted to microsoft.public.excel.programming

Rob

external usenet poster

Posts: 718

EVALUATE method returns zero

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Evaluate Method Returns Type Mismatch	todtown	Excel Programming	9	November 20th 07 11:26 PM
Evaluate Method Returns Type Mismatch	todtown	Excel Programming	0	November 20th 07 07:26 PM
Evaluate Method Returns Type Mismatch	todtown	Excel Programming	0	November 20th 07 07:26 PM
EVALUATE Method and arguments	lumpus	Excel Programming	0	September 25th 07 08:40 PM
Strange (?) Evaluate Method Behavior	Johnny Meredith	Excel Worksheet Functions	0	March 3rd 06 02:28 PM

All times are GMT +1. The time now is 02:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us