First, your arugments have to be passed as Ranges, not strings.
for instance, if I record it I get:
Application.Run "ATPVBAEN.XLA!Histogram", _
ActiveSheet.Range("$B$4:$B$27"), _
"", ActiveSheet.Range("$D$4:$D$9"), _
False, False, False, True
as an example.
You can find documentation in the help files for the Excel4 macro language:
http://office.microsoft.com/downloads/2000/Xlmacro.aspx
http://support.microsoft.com/default...85&Product=xlw
Macrofun.exe File Available on Online Services
xl97 (old winhelp format)
http://support.microsoft.com/default...66&Product=xlw
XL97: Macro97.exe File Available on Online Services
xl97 (old winhelp format)
--
Regards,
Tom Ogilvy
"Michael Moser" wrote:
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