I want to calculate the quadratic regression for a number of columns and display the results. I want to be able to increment ONLY the column referenece (Letter E) from linest equation and the row reference from .Range("B6:D6"). (Number 6 would increment and the columns would stay the same). The code I have so far is shown below. This works well just for column E and displays it in range B6:D6. I want to repeat this by looping through the columns (E to GT) in the linest formula and display the corresponding results in B[rownumber] : D[rownumber].
How do I change the code to suit what I'm trying to do?![]()
Dim X X = Application.Evaluate("=LINEST('V Az or H El'!$A3:$A42,'V Az or H El'!$E3:$E42^{1,2})") Worksheets("Quadratic Regression").Range("B6:D6") = X
Bookmarks