VBA ATP arguments

J

Jim

Is there a good resource that lists the arguments that need to follow Application.Run "ATPVBAEN.XLA!Random"? The problem is that there are 7 different types of distributions that can be created with that function, and each one apparently has a different number and order of the arguments

Thanks in Advance.
 
C

Chip Pearson

Jim,

The arguments you would pass in the VBA code are the same as
those used in a worksheet call to the function. See Excel's help
for the function to determine the relevant arguments.


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


Jim said:
Is there a good resource that lists the arguments that need to
Click to expand...
follow Application.Run "ATPVBAEN.XLA!Random"? The problem is
that there are 7 different types of distributions that can be
created with that function, and each one apparently has a
different number and order of the arguments.
 
J

Jim

Thanks for the quick reply. Normally I would access the function through the Tools menu, Data Analysis, and then picking Random Number Generation, which brings up a dialog box where the parameters are entered that will define the distribution. I do not see a worksheet function that does this, and cannot find lists of arguments in help under "random". "random number generation analysis tool" help does not list them either. Am I missing something? Recording a macro while using the dialog box method and then viewing the macro code helps, but still leaves a few blanks


----- Chip Pearson wrote: ----

Jim

The arguments you would pass in the VBA code are the same a
those used in a worksheet call to the function. See Excel's hel
for the function to determine the relevant arguments


--
Cordially
Chip Pearso
Microsoft MVP - Exce
Pearson Software Consulting, LL
www.cpearson.co


Jim said:
Is there a good resource that lists the arguments that need t
Click to expand...
follow Application.Run "ATPVBAEN.XLA!Random"? The problem i
that there are 7 different types of distributions that can b
created with that function, and each one apparently has
different number and order of the arguments
 
Top