Please ignore this question - I've managed to work out a solution based on
previous posts requesting the same for polynomial trendlines.

"Andy" wrote:

Hi all
Does anybody know if it is possible to capture the data contained in a
trendline legend using VBA. Specifically I am interested in the getting the
base and exponent values of the y function. Currently I have a series of
input boxes that prompt the user to enter the base and exponent values
respectively (as they can see them on the chart). However, it would be cool
if I could get the code to do all this. Can anybody help please?!
Thanks
Andy