Nevermind I got it! Apparently there is a separate Analysis Toolpak - VBA that you have to enable which is separate from the regular Analysis Toolpak. Very cool code! Thanks p45cal! You rock!