Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding Histogram add in tool
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating blank or null cells that the Histogram Data Analysis tool will ignore | Excel Worksheet Functions | |||
I was creating a histogram; now i have data but no histogram. | Excel Worksheet Functions | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel | |||
Implant macro coding into ASP coding | Excel Programming | |||
Histogram tool | Excel Discussion (Misc queries) |