Sub copia() Dim X, Ur, Rg Ur = Sheets("Foglio1").Range("A" & Rows.Count).End(xlUp).Row Rg = 2 For X = 2 To Ur If Cells(X, 4) > 0 Then Sheets("Foglio1").Range("A" & X & ":D" & X).Copy Sheets("Foglio2").Range("A" & Rg).PasteSpecial Rg = Rg + 1 End If Next X End Sub