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 |
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 |
All times are GMT +1. The time now is 09:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com