Changing trend lines with macro

[Brisbane Rob]

Hi

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

[Tushar Mehta]

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 <[email protected]>,
[email protected] 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
>
>