c bon g trouve tt seul
merci qd même
voila le code final
Sub try()
Selection.Merge
Range("B13").Select
Sheets("Feuil1").Select
Range("AA8").Select
Do Until ActiveCell = ""
If ActiveCell = "0" And ActiveCell.Offset(0, -26) <> "Desserte routiere" Then
Selection.EntireRow.Clear
End If
ActiveCell.Offset(1, 0).Range("A1").Select
Loop
For lin = Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
If Rows(lin).Find("*") Is Nothing Then Rows(lin).Delete
Next lin
End Sub