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" wrote in messag
..
Is there a good resource that lists the arguments that need t
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
Thanks in Advance