Sub supp()
Dim i As Integer
For i = Range("A65536").End(xlUp).Row To 2 Step -1
If Cells(i, 1) = 0 And Cells(i, 1) <> "" Then Rows(i).Delete
Next i
End Sub
for n=1 to 256
if cells(ligne,n).value=0 then
rows(n).delete
exit for
end if
next n
Sub test()
Dim i As Integer, c As Range
For i = Range("A65536").End(xlUp).Row To 1 Step -1
Set c = Rows(i).Find(0, , xlValues, xlWhole, , , False)
If Not c Is Nothing Then Rows(i).Delete
Next i
End Sub
Sub supp()
Dim i As Integer
Dim j As Byte
For i = Range("A65536").End(xlUp).Row To 2 Step -1
For j = 1 To Cells(i, 255).End(xlToLeft).Column
Cells(i, j).Select
If Cells(i, j) = 0 And Cells(i, j) <> "" Then
Rows(i).Delete
Exit For
End If
Next j
Next i
End Sub
For n= range("A65536).end(xlup).row to 1 step -1
if range("A" & n)=0 or range("A" & n) = "0" then rows(n).delete
next n
For n= range("A65536[COLOR=red]"[/COLOR]).end(xlup).row to 1 step -1
if range("A" & n)=0 or range("A" & n) = "0" then rows(n).delete
next n