Option Explicit Sub Inserisci_Formule() Dim riga As Long riga = 3 'inizia da riga 3 Do While Range("A" & riga) <> "" Range("A" & riga).EntireRow.Insert 'inserisci riga vuota Range("A" & riga) = Range("A" & riga - 1) 'copia data 'inserisci formule Range("B" & riga & ":D" & riga) = Array("=AVERAGE(R[-1]C,R[1]C)", "=AVERAGE(R[-1]C,R[1]C)", "=AVERAGE(R[-1]C,R[1]C)") riga = riga + 3 Loop End Sub