Custom Functions

P

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
 
N

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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top