Kirsty, check out the below link

http://support.microsoft.com/default.aspx/kb/192642

If this post helps click Yes
---------------
Jacob Skaria


"Kirsty" wrote:

Hi,

I am trying to use the Add in histogram tool in a macro, i have recorded the
macro, which occurs as shown but it does not record the ranges. How do I put
these in?

The ranges are
Input range $R$2:$R$262
Bin Range $Y$2:$Y$49 and
output range $Z$1

Sub tmp()
'
' tmp Macro
' Macro recorded 20/10/2009 by kirsty.m.liddicoat
'

'
Application.Run "ATPVBAEN.XLA!Histogram", , , , False, False, False, _
False
End Sub