You need to:
- Select "Analysis Toolpack - VBA" as an Add-in
and
- Add a reference to it in VBA: Select Tools/References, and
check atpvbaen.xls (possibly the "en" part will be different
for non-English versions of Excel)

The extra functions will then be available in VBA.





Bruno Campanini wrote:
"Nuraq" wrote in message
...
How can I use the XIRR function provided in the Analysis Toolpak in VB?

Good question!
IRR is both a worksheet and VBA function;
some other functions, like MAX(), are worksheet
functions you can use in VBA with WorksheetFunction.MAX().
XIRR is a worksheet function which is not listed among the
ones to be also used in VBA with WorksheetFunction.XIRR().

I am with you waiting for somebody else's discovery...

Bruno