How to use Tools, Data Analysis, Regression in Macros

G

Guest

I am trying to write a macro that includes using 'Regression' in "Data
Analysi"s but the Macro recorder will not recognise the actions.
 
M

Mike Middleton

Bruce Edwards -
I am trying to write a macro that includes using 'Regression' in "Data
Analysi"s but the Macro recorder will not recognise the actions. <
Click to expand...

As a workaround, you could avoid trying to use the Regression tool (which
requires that the Analysis ToolPak add-in be installed) and instead use
Excel's built-in LINEST array-entered worksheet function (perhaps with
OFFSET to get specific results).

- Mike
www.mikemiddleton.com
 

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
Recording Regression in Macros 1
Calling Regression Toolpack in a Macro 1
Do Multiple Regression with VBA Code 2
1004 error when using ATPVBAEN.XLAM!Regress 7
Data analysis Regression in vba 4
Exporting Data to Excel from Access for Analysis 1

Top