| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert xla add-in to xlam? | Excel Discussion (Misc queries) | |||
| How do I convert xla add-in to xlam. | Excel Programming | |||
| Convert xla add-in to xlam. | Excel Programming | |||
| Cannot run the macro 'LOOKUP.XLAM!GetLookup | Excel Discussion (Misc queries) | |||
| call to macro in xlam from macro in xlsb | Excel Programming | |||
Hybrid Mode
