Worksheet function

[Guest]

Hi,

I need help ! I am using the functions Weibull, Normal, Lognormal, etc ...
in my worksheets and it is running correctly. But now I need to use this
function in a VBA code but VBA does not support this "function" (formula).
VBA does not recognise its.

I have checked the help file and it shows me that this function runs in
worksheet envioroment but does not explain how use in VBA code.

How could I call this function through VBA code ?

Thanks,

Saboto

 

[Chip Pearson]

These functions are part of the Analysis Tool Pak, so you need
the Analysis Tool Pak VBA add-in installed to use them. In Excel,
go to the Tools menu, choose Add-Ins, and put a check next to
"Analysis Tool Pak - VBA". Then go into VBA, go to the Tools
menu, choose References, and put a check next to "atpvbaen.xls".
Once you have this reference in place, you can use these
functions as if they were native VBA functions.


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