Hi All,
I got problem when using the LINEST function (linear regression). How do one add the value of the slope to a cell?
I use the code below but I get the #VALUE! message in the cell. The cell's format is General.
What is wrong here?![]()
Dim v As Variant Dim x As Variant Dim Y As Variant x = Range("B2:B3") Y = Range("D2:D3") v = Application.LinEst(Y, x, True, True) Worksheets("Sheet1").Range("H1").Value = v
Cheers!
Bookmarks