1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| Sub Moving()
Dim cell As Range
Dim datarange
Dim WsSrc As Worksheet
Dim Wsdest As Worksheet
Set datarange = Sheets("Moving").Range("D:D")
Set WsSrc = Sheets("Moving")
Set Wsdest = Sheets("déploiement")
With WsSrc
Range("D1:D3000").Replace What:="GL00X", Replacement:="ARPEGE\X", LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D1:D3000").Replace What:="GL00", Replacement:="ARPEGE\A", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End With
For Each cell In datarange
If Left$(cell.Value, 8) = "ARPEGE\A" Then
cell = Left(cell.Value, Len(cell.Value) - 1)
End If
Next
End Sub |
Partager