XNPV Function

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XNPV in VBA 2
Cannot verify XNPV with PV or HP-12C 4
Zero or negative rates and XNPV? 4
XNPV function with starting point dependant on date 0
nested if function 5
Problem with Yield() function 5
XIRR FUNCTION 6
Problem using XNPV from VBA 0

Top