Need to add new columns to right AND execute formulas that change as new columns are added

I'm looking to loop 2 formulas n number of times in new columns to the right each time. I converted my Range formula to the R1C1 version in the hopes I could use an object to increase the column number a loop but I don't know how to get the i variable to work in a R1C1 formula. The Cells(r, c) works with the object but any variation of it within the formular1c1= either fails or just prints i

Please Login or Register  to view this content.

Thanks