Dim nom As String Dim feuille, feuilleAjout As Worksheet Dim cellule, cell As Range Set feuille = ActiveSheet Set cellule = feuille.Range("A1") nom = "" While Not IsEmpty(cellule) If cellule.Value <> nom Then nom = cellule.Value Set feuilleAjout = Sheets.Add(after:=Worksheets(Worksheets.Count)) feuilleAjout.Name = nom Set cell = feuilleAjout.Range("A1") cell = cellule.Value Set cell = cell.Offset(1, 0) Else cell = cellule.Value Set cell = cell.Offset(1, 0) End If Set cellule = cellule.Offset(1, 0) Wend