Insert formula every nth Row?

[Retail_Therapy]

From Columns AN to BB (15 columns in total), I have a match/index formula that needs to be inserted every 11th row.
Does anyone know of a VBA code to perform this?

Note: each of the 15 column is a unique match/index formula catered to that specific column cell.

Thank you in advance,
Kim

 

[Joe4]

If you know the number of rows you want to copy it down for, it is much simpler, i.e.

Sub MyInsert()

    Dim r As Long
    
    Application.ScreenUpdating = False
    
'   Loop until column AN is blank
    For r = 5 To 2942 Step 11
'       Insert blank row
        Rows(r).Insert
'       Insert formulas
        Cells(r, "AN").Formula = "=ROW()"
        Cells(r, "BB").Formula = "=COLUMN()"
    Loop
    
    Application.ScreenUpdating = True
    
End Sub