Hi,
Hi, I feel like this is a simple question, but I'm not getting any results from Mr. Excel where this question is cross posted: http://www.mrexcel.com/forum/excel-q...matically.html so I figured I'd try here.

I tried the macro recorder tool, but it won't capture my actions within the data analysis pack for some reason.

I have the data analysis pack installed on my Excel 2010/2013. I'm trying to create VBA code that does the following:

1. Opens up the Linear Regression Tool
2. For the Y Range: C1:Last Row in column C
3. For X Range: A1:Last Row in column B
4. Check off the box for Labels
5. Check off the Confidence Level and ensure its set to 95
6. Select Output Range and set it to M1

Any ideas?

Thank you very much