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

Problem converting script from Excel 2003 to Ecel 2007 1
call to macro in xlam from macro in xlsb 1
How to call a macro from a xlam in a xlsm 3
How do I call Fourier Analysis in Excel2007 in a macro? 7
Custom Excel 2007 Tab disappears when editing an XLAM add-in file 10
Missing:ATPVBAEN.XLA 10
Coding Histogram add in tool 1
Big dataset - batch process 1

Top