Coding Histogram add in tool

K

Kirsty

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS EXCEL - To supress warning messages created by Anlysis ToolPak 1
Histogram Invalid Reference 5
Newbie-question: recorded macro does not work - why? 3
Data Analysis Tool 5
Code to create a Histogram 5
ATPVBAEN.XLA!Histogram - macro not found 0
Formatting and copy or copy and formatting ?? 2
Using Two Range Criterion in Advanced Filter 1

Top