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, _
I have also had a similar problem trying to run the descriptive stats function.
Does anyone know a way around this.