MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro around the Histogram function


Posted by Mark O'Donnell on July 13, 2001 8:58 AM

I am wanting to record a macro around the histogram function, only to realise that there is no obviuos way of setting the range of cells for the input and output of the data.
When using the record macro function all that is returned is:
Application.Run "ATPVBAEN.XLA!Histogram", , , , False, False, True, _
True

I have also had a similar problem trying to run the descriptive stats function.

Does anyone know a way around this.
thanks
Mark



Posted by Ivan F Moala on July 14, 2001 12:08 AM

Does this help ??
Substitute your range.

Application.Run "ATPVBAEN.XLA!Histogram",ActiveSheet.Range("Input"), _
"",ActiveSheet.Range("Bin"), _
False, False, True, True


Posted by Mark O'Donnell on July 17, 2001 3:21 AM

It is still giving errors when I try to run them.

: I am wanting to record a macro around the histogram function, only to realise that there is no obviuos way of setting the range of cells for the input and output of the data. : When using the record macro function all that is returned is