Using XIRR function in VBA ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

martonec - 20 Mar 2006 20:57 GMT

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

Reply to this Message

Ron Rosenfeld - 20 Mar 2006 23:13 GMT

>Hi all,
> does anyone have a working example of the XIRR function running in
[quoted text clipped - 4 lines]
>
>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

Reply to this Message