How do I get a macro to record selections in a dialog box?

M

MAC6414

I am trying to create a macro that will generate Regression results using the
Regression function (by applying it to pre-established input data). I am
using the Record MAcro utility and going through the steps to create a simple
regression analysis. The "Record Macro" utility is not capturing the
definitions for Y, X, and output area that are entered into the Regression
Dialog box. How do I get the Macro to capture the definitions for X, Y, and
Output area?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to print LinEst result to a spreadsheet using VBA 3
Multiple (as in many) regressions 3
Macro Code for bringing up Save As dialog box and changing file Type 0
Recording Regression in Macros 1
How to save a PDF with header that extends to edge of page? 3
How do I get LINEST to show all stats? 2
Linking the Regression equation of a line to a table 1
Excel VBA Macro to do this? 19

Top