View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kirsty Kirsty is offline
external usenet poster
 
Posts: 37
Default Coding Histogram add in tool

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