Modify regression code from row 5 down to the last cell with data in a column

[csmith-han]

The following code runs 3 simple regressions for a range of data in column 3 against the range data in column 7, then 4 against 8, then 5 against 9; and gives a regression output in a separate worksheet called "Sheet2".

Looking at the Summary Output, the output values for the coefficient for the X variable and the number of observations are a little off from a manual regression output. On further investigation, the following code excludes the first row of data in row 5 and only regresses from row 6 down to the last cell within a column. I attempted to correct the code but no to avail. Can anyone please modify the following code so that macro starts the regression using inputs from row 5 down to the last cell with data in a column? Thanking you in anticipation.

Please Login or Register  to view this content.

[jewelsharma]

The issue related to the exclusion of first row is on this row of your code:

Please Login or Register  to view this content.

This TRUE sets "LABEL" as TRUE, implying the range in rngY and rngX variables has a label/heading in the first row, and therefore is excluded.

Simply change this TRUE to FALSE. The rest of the code is fine.
HTH!

[csmith-han]

Dear jewelsharma, great advice. Thank you for your help