Sub recopie()
isheetMaxi = Sheets.Count
Sheets(1).Select True
derniereFeuilleAcopier = 0
For i = 1 To isheetMaxi - 1
If Sheets(i).Name = "FIN" Then
derniereFeuilleAcopier = i
End If
Next i
For i = 1 To derniereFeuilleAcopier - 1
Sheets(i).Select False
Next i
'Selection.Copy
End Sub