I replied to your post an hour ago. What I wrote was....


To call functions in the ATP, once you have set a reference to
the Add-In, simply call them by name, without any prefixing.

rngXIrr = XIrr(...)

If there is a possibility of name collision (e.g., you have a
function with the same name as an ATP function), you can prefix
the function with the library name:

rngXIrr = [atpvbaen.xls].XIrr(...)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CyberBuzzard" wrote in message
...
I have setup the reference to ATPVBAEN.XLS in my project, the
Add-In is
installed in Excel, I also found the function in the Object
Browser under
atpvbaen.xls.VBA Functions and Subs.

Nevertheless I can't make my code work, getting the "Object
doesn't support
this property or method" prompt, when writen like this:

rngXIrrCalc =
Application.WorksheetFunction.XIrr(rng1, rng2)

I would greatly appreciate if someone can help me with this.

--
Any help will be appreciated.

Regards,

CyberBuzzard