Trendline coefficient extraction code

Hello

I recently found the code below posted in a thread and have been trying to make use of it as it does exactly what I needed to achieve.

The code works beautifully (I am using the TLcoef function) with just one issue. When I save, close and then return to the workbook, the error message '"#Err: No trendline matches the specified parameters" appears where the array should be, even though nothing has changed except for going out and in again. Also (strangely) I can no longer select any cells on the sheet.

Does anybody have any idea why this may be happening and what I can do about it?

Thanks in advance

Josie

(code in next thread)