Macro not working with XLAM add-in

B

B Bean

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
 
D

Dave Peterson

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

B Bean

It worked - thanks a bunch!!

Dave Peterson said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Problem converting script from Excel 2003 to Ecel 2007 2
Menu Macro Not Executing - Need Help 1
How to call a macro from a xlam in a xlsm 3
Change a great number of words in word files, with a macro as short as possible. 5
call to macro in xlam from macro in xlsb 1
Big dataset - batch process 1
How do I call Fourier Analysis in Excel2007 in a macro? 7

Top