Using XIRR function in VBA ?

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

On 20 Mar 2006 11:57:04 -0800, "martonec" <tony@martonec.com> wrote:

>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