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