Hi all,
I have the below macro. I am trying to get it to loop. Where each time the R[-1] part increases by 1 and keeps repeating until it finds an empty cell
Sub Test
Sheets("Sheet1").Select
Range("C3").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 =...