(Cross-posted here: http://www.mrexcel.com/board2/viewtopic.php?t=285789 It gets buried pretty fast)

I looked through some code that generates trend lines, but I can't seem to find anything that can capture the R squared produced by the trend line created. Is there a way to do that?
If there is, I would like to see if there's a way to loop through several trend lines, find the one with the highest R squared, and draw that one?