View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default WorksheetFunction.Sumproduct(syntax...

David,

Evaluate it

?evaluate("SumProduct(2,3)")

--

HTH

RP

"David" wrote in message
...
Thanks for any advice you may give
Can anyone please advise on the syntax for the arguments in the above
function?
I've tried: ?Application.WorksheetFunction.Sumproduct(2,3) .. expecting to
result with 6 but get the error message: "Unable to get the property of

the
worksheet function class"
--
David