Hi All,

This my first post, so I hope that I am able to give all needed information.

I am trying to create a macro that based on the Data Analysis Tool create a histogram, with the following specifications

1. Leave the bin range blank
2. Table for the "Bin" & "Frequency"values to be pasted in the same sheet where there is the input range ("Histograma QA")
3. Do not want to draw any chart.

My main problem is that I do not know how to omit the bin range and keep getting the error mentioned in the Title. Here is the code:

Application.Run "ATPVBAEN.XLAM!Histogram", ActiveSheet.Range("$W$1:$w$6000"), True, False, _
False, False

Any help, will be appreciated.

Thanks in advance