Histogram Macro : bin range issue

Hi there,

I need to call the Histogram function, from Data Analysis, on vba.

Here is the code :

Please Login or Register  to view this content.

The only thing is that I don't want any bin range.

The syntax is Histogram(inprng, [outrng], [binrng], [pareto], [chartc], [chart], [labels]), and when I leave the binrng empty, i got the error message : "Histogram - bin range cannot be empty"

I tried to write "", or FALSE, but it doesn't work.

Any idea ?

Thanks,

Does anybody know how to set the "bin range" to "nothing" ?

I didn't find how to leave the bin field empty, so I initialized id, taking a range from the Max and the Min of my input range, and setting the bin number on ActiveSheet.Cells(3, 16)

And it works !


It may help someone..

Please Login or Register  to view this content.