I want to put a formula in a selected region of cells which changes after every pass in a for loop.

This is what works for column G, but I want to have the column change each pass.

Selection.AutoFill Destination:=Range("G3:G207"), Type:=xlFillDefault

Something like this is what i need:

Selection.AutoFill Destination:=Cells(3:finalrow, x+offset), Type:=xlFillDefault

Can I somehow use Range() with numbers for the column? How about doing it using Rows()?

Thanks!