I'm trying to retrieve the r2 from LINESt results via VBA--I don't want to
create a chart and pull it from the chart's trendline. I can retrieve m and b
with no problem, but when I try the following I get an error.

r2 = Application.Evaluate("=index(linest(" & Selection.AddressLocal() &
",,,TRUE),3)")

Any and all help greatly appreciated.
Thanks,
j