how to use histogram in vba code - analysis toolpack

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use histogram as provided in analysis toolpack using visual basic
macro but could not do that. Is there a way to code for this?
 
Use the add-in Anaylsis ToolPack VBA - then use

Application.Run "ATPVBAEN.XLA!Histogram"

You will need to set the parameters for this command and the best way is to
turn on the macro recorder and set up the histograms options in the wizard.
You can then adapt the recorded macro within your VBA program code.
 

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

Help - Calling Analysis Toolpak Functions from Outlook Macro 2
An alternative for the edate function... 4
Excel - Analysis Toolpack loading problem 2
Solver in VBA 4
MS EXCEL - To supress warning messages created by Anlysis ToolPak 1
Coding Histogram add in tool 1
Installation of "Add-Ins" in code 7
Excel 2007 wont import Excel 2003 VBA module 1

Back
Top