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
Bookmarks