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?

 Application.Run "ATPVBAEN.XLAM!Regress", _
    ActiveSheet.Range("$D$2:$D$52"), _
    ActiveSheet.Range("$L$2:$L$52"), _
    False, False, , ActiveSheet.Range("$P$2"), _
    False, False, False, False, , False

[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