How do I call a function from the Analysis Toolpak add-in in a user
function?

Application.worksheetfunction. does not work

How do i reference a function for the Toopak add-in?

PWS

In the VBE: ToolsReferences, check atpvbaen.xls
you can then use the functions as if they were intrinsic vbs functions (no prefixes);

Sub test()
Debug.Print eomonth(Date, 15)
End Sub

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PWS" wrote in message ps.com...
| How do I call a function from the Analysis Toolpak add-in in a user
| function?
|
| Application.worksheetfunction. does not work
|
| How do i reference a function for the Toopak add-in?
|
| PWS
|