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.
Bookmarks