ExcelBanter - Macro not working with XLAM add-in

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro not working with XLAM add-in (https://www.excelbanter.com/excel-programming/431692-macro-not-working-xlam-add.html)

B Bean

Macro not working with XLAM add-in

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

Macro not working with XLAM add-in

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

B Bean

Macro not working with XLAM add-in

It worked - thanks a bunch!!

"Dave Peterson" wrote:

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

All times are GMT +1. The time now is 11:27 AM.