Thread: Macro not working with XLAM add-in
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
B Bean B Bean is offline
external usenet poster
  
Posts: 2
Default 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

Reply With QuoteReply With Quote