Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XIRR FUNCTION | Excel Worksheet Functions | |||
XIRR - Function Missing | Excel Discussion (Misc queries) | |||
Please help for FV and XIRR function. | Excel Worksheet Functions | |||
xirr function | Excel Worksheet Functions | |||
XIRR function | Excel Worksheet Functions |