Analysis ToolPak-VBA Addin for Mac

[2chainz]

I'm trying to run the Regression function from the Analysis Toolpak in VBA. When I run the code below I get
"Run-time error '1004':
Application-defined or object-defined error"
When I try to record the regression with a macro, nothing shows up in the macro.

I think the problem is that I do not have Analysis Toolpak-VBA. The add-ins that I have installed is Analysis Toolpak and Solver. These are the only options I get to pick when I try to install add ins. How do I get Analysis Toolpak-VBA for Mac Excel 2016?

Please Login or Register  to view this content.

[xlnitwit]

Hi,

There is no such add-in for the Mac. The Analysis Toolpak wasn't even available on Mac prior to the 2016 version.

[2chainz]

Does that mean I cannot do Analysis Toolpak regression in VBA?

[Alf]

See link

https://support.microsoft.com/en-us/kb/2431349

Alf