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

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