Hello Rob,

The Analysis ToolPak is an Excel Add-In. First you must start the Excel
application and then load the Analysis ToolPak. Then the histogram
function will be available.

*Check if Add-In is Installed: *
Dim A1, A2

Set A1 = xlobj.Addins("Analysis ToolPak")
Set A2 = xlobj.Addins("Analysis ToolPaK-VBA")

If A1.Installed = FALSE Then A1.Installed = TRUE
If A2.Installed = FALSE Then A1.Installed = TRUE

To Uninstall before your quit Excel, set A1 and A2 to FALSE.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=496216