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

Using XIRR function in VBA ?
 

On 20 Mar 2006 11:57:04 -0800, "martonec" 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