extracting the trendline equation

[Guest]

I've written a macro to extract the trendline equation and change it from text to a calculation in a cell
The macro works untill it has to remove the "y=" and replace it with "=". This works when I do it manually but the macro fails at this point each time
Can anyone help or offer a better solution

MikeG

 

[Jon Peltier]

Mike -

Dave Braden's posted some code to extract the coefficients of the
trendline equation:

http://www.google.com/[email protected]

- Jon

 

[Bernard Liengme]

Why not use LINEST?
See www.stfx.ca/people/bliengme/ExcelTips

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

I've written a macro to extract the trendline equation and change it from

text to a calculation in a cell.

The macro works untill it has to remove the "y=" and replace it with "=".

This works when I do it manually but the macro fails at this point each
time.