sub test()
Dim cell as range
For each cell in activesheet.usedrange
if cell.value=0 then cell.entirerow.delete
Next
end sub
'On supprime les lignes qui ont été déplacées et qui sont maintenant vides
j = 2
While wk1.Worksheets("Bidos").Cells(j, 1) = ""
wk1.Worksheets("Bidos").Rows(j).Delete
j = j + 1
Wend
Dim i As Long
For i = Range("A65536").End(xlUp).Row To 2 Step -1
If Cells(i, 1) = "" Then Rows(i).Delete
Next i