1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub test()
Dim Plage As String
Plage = "F4:LZ42"
ReplaceZéro Range(Plage)
For i = 1 To 9
ReplaceChar Range(Plage), CStr(i), "0"
Next
ReplaceChar Range(Plage), "0", "1"
ReplaceChar Range(Plage), "[A]", "0"
End Sub
Sub ReplaceZéro(R As Range)
R.Replace What:="0", Replacement:="[A]", LookAt:=xlWhole, _
SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Sub ReplaceChar(R As Range, Val1 As String, Val2 As String)
R.Replace What:=Val1, Replacement:=Val2, LookAt:=xlPart, SearchOrder _
:=xlByColumns, MatchCase:=False, SearchFormat:=False, ReplaceFormat:= _
False
End Sub |
Partager