Option Explicit Sub Aggiungi_e_Somma() Application.ScreenUpdating = False Dim NRc As Long, z As Long Dim x As Integer, RgX As Integer, RgY As Integer Dim y As Byte RgX = 8 y = 10 NRc = Range("A" & Rows.Count).End(xlUp).Row / 10 For z = 1 To NRc If Cells(RgX, 1) <> "" And Cells(RgX + y, 1) <> "" Then Cells(RgX + y, 1).EntireRow.Insert Cells(RgX + y, 9).FormulaR1C1 = "=SUM(R" & RgX & "C9:R" & RgX + y - 1 & "C9)" Cells(RgX + y, 10).FormulaR1C1 = "=SUM(R" & RgX & "C10:R" & RgX + y - 1 & "C10)" Range(Cells(RgX + y, 9), Cells(RgX + y, 10)).Font.Color = -16776961 End If RgX = RgX + y + 1 Next z NRc = Range("A" & Rows.Count).End(xlUp).Row + 1 Cells(NRc, 9).Select Application.ScreenUpdating = True End Sub
Option Explicit Sub Aggiungi_e_Somma() Application.ScreenUpdating = False Dim NRc As Long, z As Long Dim x As Integer, RgX As Integer, RgY As Integer Dim y As Byte RgX = 8 y = 10 NRc = Range("A" & Rows.Count).End(xlUp).Row / 10 For z = 1 To NRc If Cells(RgX, 1) <> "" And Cells(RgX + y, 1) <> "" Then Cells(RgX + y, 1).EntireRow.Insert Cells(RgX + y, 9).FormulaR1C1 = "=SUM(R" & RgX & "C9:R" & RgX + y - 1 & "C9)" Cells(RgX + y, 10).FormulaR1C1 = "=SUM(R" & RgX & "C10:R" & RgX + y - 1 & "C10)" Range(Cells(RgX + y, 9), Cells(RgX + y, 10)).Font.Color = -16776961 End If RgX = RgX + y + 1 Next z NRc = Range("A" & Rows.Count).End(xlUp).Row Cells(NRc, 1).Select Selection.End(xlUp).Select RgY = ActiveCell.Row Cells(NRc + 1, 9).FormulaR1C1 = "=SUM(R" & RgY & "C9:R" & NRc & "C9)" Cells(NRc + 1, 10).FormulaR1C1 = "=SUM(R" & RgY & "C10:R" & NRc & "C10)" Range(Cells(NRc + 1, 9), Cells(NRc + 1, 10)).Font.Color = -16776961 Application.ScreenUpdating = True Range(Cells(8, 9), Cells(NRc + 1, 10)).NumberFormat = "#,##0" End Sub