Custom Functions

[PWS]

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

 

[Niek Otten]

In the VBE: Tools>References, 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

| 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
|