Hi,

I am trying to call the Data Analysis Random Number Generator from a Macro.
My range of Values and Probabilities is in Sheet 1 in the range A1:B4 and is
named MyRange.

My macro is:

Sub GenRandomNumbers()

Application.Run "ATPVBAEN.XLA!Random", ActiveSheet.Range("$a$15"), 1,
99, _
7, , ActiveSheet.Range("MyRange")

End Sub

This works fine until I move away from using ActiveSheet. If I try to run
the macro using explicit sheet references, the macro fails as in the
following example:

Sub GenRandomNumbers()

Application.Run "ATPVBAEN.XLA!Random", Sheet2.Range("$a$15"), 1, 99, _
7, , Sheet1.Range("MyRange")

End Sub


I would appreciate any guidance the group can provide. I am also interested
in finding out how I can find the list of arguments for a called function
like this.

Thanks,

Frank Hayes