Sub noviceAG()
Dim k As Byte
With Sheets("Feuil1")
For k = 10 To 40
If .Cells(k, 13) = "" Then
'.../... l'action à faire
End If
Next
End With
End Sub
Sub noviceAG()
Dim k As Byte
With Sheets("feuil1")
For k = 10 To 40
If .Cells(k, 13) = "" Then .Range("A" & k & ":L" & k).ClearContents
Next
End With
End Sub
Sub efface()
Intersect([A10:L40], [M10:M40].SpecialCells(xlCellTypeBlanks).EntireRow).ClearContents
End Sub