VBA to enter a formula in a series of cells in column A

[chaddres]

I have a spreadsheet and I need to enter the same formula in each cell in Column A from cell A2 to the end of the column (wherever the data ends)

The formula I need is A2 = G2&I2, then A3 = G3&I3 and so on.

I am at a complete loss on this.

 

[steve the fish]

Try:

Sub Fill()
Range("A2:A" & Range("G" & Rows.Count).End(xlUp).Row).FormulaR1C1 = "=RC[6]&RC[8]"
    
End Sub

 

[chaddres]

Perfect! Thank you so much.