XNPV Function

[David]

I'm using Excel 2007 and I'm trying to calculate XNPV for a certain
array within VBA. Within Excel, the XNPV function asks for 3
arguments: XNPV(rate,value,dates), but within VBA, it is only asking
for 2 arguments. When I looked up XNPV within the Excel Help, it says
the function calls for 2 arguments, but gives an example with 3. When
trying to use three arguments I get a compile error with this message:
"Wrong number of arguments or invalid property assignment" I know it
is not an invalid property assignment because I am using the XIRR
function (which only requires 2 arguments) with the same arrays.
Anyone have a solution? Here is code:

Range("H50") = WorksheetFunction.Xirr(NetCFAC, DateSet()) -- THIS
WORKED
Range("D49") = WorksheetFunction.Xnpv(0.05, NetCFAC, DateSet()) --
THIS DOES NOT WORK

Thanks

 

[Pat Coogan]

I am having the same problem.
Did you find a solution for this yet?