Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have enabled the add-in ("Analysis ToolPak" and ("Analysis ToolPak
VBA") in Excel (this package seems to come with Excel by default - I didn't have to install anything special, just had to check the tick-mark in Tools = Add-Ins). This made another Tools-menu entry appear: "Data Analysis" This all works fine, but now I wanted to automatize a few things to save me some substantial typing and clicking when (re-)generating charts. So I recorded a macro that uses a function from that add-in (Tools = Data Analysis = Histogram). In the recorded macro of this action shows up as: ---------------------- .... Application.Run "ATPVBAEN.XLA!Histogram", , , , False, False, False, _ False .... ---------------------- When I want to execute/replay the macro I always get an error popup telling me: "Histogram - inout range must be a contiguous reference". I thought, that maybe the series of empty ', , , ,' indicates some missing or non-recorded range inputs (namely the input range, the "buckets" and the output range that I entered during recording) and tried to fill the void so that the line read ---------------------- .... Application.Run "ATPVBAEN.XLA!Histogram", "$B$10:$K$508", "$O$2:$O$255", "$P$1:$Q$256", False, False, False, _ False .... ---------------------- .... but that did not work either and so I am stuck. Any idea, what to do here or what I am missing? How/where can I find some documentation re. what parameters that Histogram-operation expects? Any help would be greatly appreciated! Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Newbie Macro Question | Excel Discussion (Misc queries) | |||
I recorded a macro "PrintSetUp" in excel but does not work | Excel Worksheet Functions | |||
newbie macro question | Excel Programming | |||
Newbie he I have a question about a print macro I am trying to write... | Excel Programming | |||
flip an autoshape using VBA- recorded macro doesn't work | Excel Programming |