Changing trend lines with macro

Hi

Has anyone ever worked out a way of changing trend lines (from say linear to moving average) using a macro?

Turn on the macro recorder (Tools | Macro > Record new macro...), make the
change through the UI, turn off the recorder, and switch to the VBE. XL
will have generated the necessary code that you can customize/generalize as
required.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <Brisbane.Rob.2b9e4i_1153424109.7478@excelforum-nospam.com>,
Brisbane.Rob.2b9e4i_1153424109.7478@...rum-nospam.com says...
>
> Hi
>
> Has anyone ever worked out a way of changing trend lines (from say
> linear to moving average) using a macro?
>
>
> --
> Brisbane Rob
> ------------------------------------------------------------------------
> Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
> View this thread: http://www.excelforum.com/showthread...hreadid=563454
>
>