val1 = spécifier la valeur val2 = spécifier la valeur Range("A1:An100").Select Selection.Replace What:=val1, Replacement:=val2, LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Sheets("blabla").Range("A1").Value = ""
Dim Plage As Range, Cellule As Range Set Plage = Sheets("blala").Cells("A1:B10") For Each Cellule In Plage.Cells If Cellule.Value > 0 Then Cellule.Value = "" End If Next
Dim Plage As Range, Cellule As Range Set Plage = Sheets("blala").Range("A1:B10") For Each Cellule In Plage.Cells If Cellule.Value > 0 Then Cellule.Value = "" End If Next