Using XIRR function in VBA ?

[martonec]

Hi all,
does anyone have a working example of the XIRR function running in
VBA or VB ?
I am pulling what's left of my hair out here. I can run the function ok
but the result is not what I'm expecting. I think I'm obviously going
wrong somewhere along the line. Any help would be greatly appreciated.

Tony

 

[Ron Rosenfeld]

Hi all,
does anyone have a working example of the XIRR function running in
VBA or VB ?
I am pulling what's left of my hair out here. I can run the function ok
but the result is not what I'm expecting. I think I'm obviously going
wrong somewhere along the line. Any help would be greatly appreciated.

Tony

It runs like any other worksheet function, EXCEPT you should have set a
reference to APTVBAEN.XLA and you would just call it directly (no
application.worksheefunction preceding).

e.g.

Dim res as double

res = xirr(values, dates, holidays)


--ron