Would it be too hard for Microsoft to provide some useful instructions about statements and their arguments???!!!!
Where, if anywhere, does Microsoft keep instructions about the parameter arguments for the various Analysis Tools in Analysis ToolPak? Specifically, for the VBA file, atpvbaen.xla, the Histogram analysis tool, I want to know what the 4th through 7th arguments are, and what their acceptable values are. I looked on MSDN. I certainly looked on Excel and Excel VBA help screens.
It’s easy to figure out the first three arguments. My example:
Application.Run “ATPVBAEN.XLA!Histogram”, _
ActiveWorkbook.Names(“Histo_Data”).RefersToRange, _
Sheets(“Analy Histo”).Range(“$F$1”), _
Sheets(“Analy Histo”).[$E$2:$E$28], _
False, False, False, False
…but the last four are undefined and untaught. I guess that they relate to the blank text boxes/address boxes in the Histogram dialog box; those are: Labels, Pareto, Cumulative Percentage, Chart Output. Are we just supposed to do trial-and-error, until we find the correct sequence for these? That’s 24 possibilities, if I’m not mistaken!
Then, multiply my question about the Histogram tool by the total number of analysis tools; surely, there is a guideline or two, hiding away somewhere in the bowels of Microsoft?
Thanks. 
