1 2 3 4 5 6 7 8 9 10 11 12 13
| Sub supprime_test()
Dim DerLigne As Integer, PremiereLigne As Long, NoCol As Integer, NoLig As Long
PremiereLigne = 2
NoCol = 21
For NoLig = 2 To 30
If InStr(1, Sheet2.Cells(NoLig, NoCol), "**BO") > 0 Then
Sheet2.Cells(NoLig, NoCol) = Left(Sheet2.Cells(NoLig, NoCol).Value, InStr(Sheet2.Cells(NoLig, NoCol).Value, "**BO") - 1) & Mid(Sheet2.Cells(NoLig, NoCol).Value, InStr(Sheet2.Cells(NoLig, NoCol).Value, "** BO END") + 3)
Else
MsgBox "Non Trouve " & Cells(NoLig, NoCol)
End If
Next
End Sub |
Partager