The order is:

Application.Run "ATPVBAEN.XLAM!Sample", _
InputRange, OutputRange, Method, Rate, Labels

So maybe:

Application.Run "ATPVBAEN.XLAM!Sample", _
worksheets("sheet9999").range("a2:a15013"), , "R", 1000, False

Change the range to what you need.


B Bean wrote:

I am trying to create a macro with the "sampling" data analysis toolpak. When
I run the following macro, I get an error that the input range is missing. I
want it to select the range A2-A15013. Any suggestions?

Application.Run "ATPVBAEN.XLAM!Sample", , , "R", 1000, False

--

Dave Peterson