Sub Dupliquer()
Dim ZoneToFilter As Range
With ActiveSheet
Pièce = .Range("C6")
FinJ = .Range("B" & .Rows.Count).End(xlUp).Row + 2
End With
With Sheets("Dupliquer")
FinDup = .Range("A" & .Rows.Count).End(xlUp).Row
Set ZoneToFilter = .Range("A1:P" & FinDup)
ZoneToFilter.AutoFilter
ZoneToFilter.AutoFilter Field:=1, Criteria1:=CStr(Pièce)
'NbLignesFiltrée = ZoneToFilter.Resize(, 1).SpecialCells(xlCellTypeVisible).Count - 1
ZoneToFilter.Offset(1, 1).SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets("Journal").Range("B" & FinJ)
' Set zone = .Range("A1:A" & FinDup).Find(Pièce)
' If Not zone Is Nothing Then
' FirstAd = zone.Address
' Do
'...