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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.