Increment the cell reference in an equation in Excel VBA

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].

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

How do I change the code to suit what I'm trying to do?

Trial and Error I am afraid.

You need to play around with the Quotation marks around & T & until it works

R=6
C=5
T = Range(Cells(3, C),Cells(42, C)) .Address
X = Application.Evaluate("=LINEST('V Az or H El'!$A3:$A42,'V Az or H El'!" & T & "^{1,2})")
Worksheets("Quadratic Regression").Range(Cells(R, 2),Cells(R, 2)) = X