Dim plage As Range, lifin As Long With Sheets("Feuil1") lifin = .Cells.SpecialCells(xlCellTypeLastCell).Row For i = 1 To lifin If UCase(.Range("E" & i)) = "X" Then If plage Is Nothing Then Set plage .Range("E" & i) Else Set plage Union(plage, .Range("E" & i)) End If Next If Not plage Is Nothing Then plage.Copy Destination:=Sheets("Test").Range("B5") End With
désolé mais je suis débutante
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub transfert() Dim lifin As Long, i As Long, j As Long j = 4 ActiveWorkbook.Save lifin = Sheets("feuil1").Range("A1").SpecialCells(xlCellTypeLastCell).Row For i = 1 To lifin If Sheets("feuil1").Range("E" & i).Value = "Input" Then Sheets("feuil1").Range("B" & i).Copy Sheets("test").Range("B" & j) Sheets("feuil1").Range("D" & i).Copy Sheets("test").Range("C" & j) j = j + 1 End If Next i end sub