How to use Tools, Data Analysis, Regression in Macros
 

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

How to use Tools, Data Analysis, Regression in Macros
 

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

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