ReDim liste(0)
'compare data Sub comparedata() Dim rng0 As Range Dim rng1 As Range Dim rng2 As Range Dim RowNo As Long Dim liste() As Integer Dim i As Integer Dim c As Range ReDim liste(0) Set rng0 = Worksheets("Feuil2").Range("A1", Worksheets("Feuil2").Range("A" & Rows.Count).End(xlUp)) Set rng1 = Worksheets("Feuil2").Range("B1", Worksheets("Feuil2").Range("A" & Rows.Count).End(xlUp)) Set rng2 = Worksheets("Feuil3").Range("E2", Worksheets("Feuil3").Range("A" & Rows.Count).End(xlUp)) For Each c In rng1 If Application.WorksheetFunction.CountIf(rng2, c) > 0 Then ReDim Preserve liste(0 To (UBound(liste) + 1)) liste(UBound(liste)) = c.Row Else If Application.WorksheetFunction.CountIf(rng0, c) Then End If End If Next c For i = UBound(liste) To 1 Step -1 Worksheets("Feuil2").Activate Worksheets("Feuil2").Range(Cells(liste(i), 1), Cells(liste(i), 100)).Delete Next End Sub
Dim Var As String, i As Integer, S As String
Var = "Parcourir la variable"
For i = 1 To Len(Var)
S = Mid(Var, i, 1) ' ici tu as les caractères qui défile
Next i
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question