The attached sheet shows where I'm at...
I am using a standard LINEST array to calculate some parameters that aren't delivered by a simple regression. The data for the LINEST are on a Table, which are (in turn ) copied from another table in the same workbook. However, the data can have some blank rows at the bottom. So, I need to make the range for the LINEST dynamic or I need to use INDIRECT to pick up the address of the last row with data in it.
I know absolutely nothing about VBA, so I need to crack it with INDIRECT. However, I can't get the syntax right. I'm trying to pick up the row number of the last data containing row from cell I2 (Attempt 1) , or the address of the last X and Y from cells I8 and I5, respectively.
What am I doing wrong? If you can reproduce the numbers that are present in the "traditional LINEST" bit, then I guess you've got it working !
Hopefully this isn't too difficult, but I can't spot what's wrong. Good luck, 'cos it's doing my head in.
Bookmarks