Option Explicit
Sub Saut_de_page_insérer()
Dim i As Integer
Application.ScreenUpdating = False
With Sheets("Feuil1")
.ResetAllPageBreaks
For i = .Cells(Rows.Count, "a").End(xlUp).Row To 1 Step -1
If .Range("a" & i).Value = "*" Then .HPageBreaks.Add Before:=.Range("a" & i)
Next i
End With
Application.ScreenUpdating = True
End Sub