I am recording and running the macro on the same pc. Nice idea though - you
never know! Thanks for your thoughts on this. I guess I shall just have to
work around this problem.



"Alok" wrote:

Hi
Is it possible that you are recording the Macro on one computer (the one
that has the Add-In) and running it on another computer that does not have
the add-in? That can explain the 1004 Error message.
I am still trying to figure out why the macro does not save the ranges!
Alok

"Andybro" wrote:

No change - the recorded macro does not show the ranges I select. I am using
an input range of $W$5:$W$75, a bin of $R$5:$R$16 and an output range of
$E$59.

If I run the macro it shows a run time error 1004, explaining that
ATPVBAEN.XLA could not be found.

"Alok" wrote:

Hi,
When I recorded a macro for histogram I got the following..

Application.Run "ATPVBAEN.XLA!Histogram",
ActiveSheet.Range("$E$8:$E$35"), _
ActiveSheet.Range("$P$8"), ActiveSheet.Range("$G$8:$G$12"), False,
False, _
False, False

I am not sure why your macro is not recording the ranges. You may like to
try again and provide all the inputs.

Alok

"Andybro" wrote:

I am trying to automate the creation of several histograms and so need to use
the "Analysis Toolpak" add-in. I have manually produced these histograms but
as I will need to refresh them weekly I wish to be able to regenerate the
histograms automatically. I tried recoding a macro which followed my method
for creating the chart. However. The VBA module does not record my input,
bin or output selection. The only line recorded is Application.Run
"ATPVBAEN.XLA!Histogram", , , , False, False, False,False

If I then run the macro this command is not recognised anyway. How can I
automate the creation of a histogram as available in the Analysis Toolpak of
Excel 2003?