View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Middleton[_4_] Mike Middleton[_4_] is offline
external usenet poster
 
Posts: 25
Default 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