Sub Bouton1_Clic()
Dim Cel As Range
Set Cel = ActiveSheet.[B65535].End(xlUp)(2)
Cel.FormulaArray = Application.ConvertFormula( _
"=""STAB-PES-16-""&TEXT(MAX(IF(LEFT(R5C:R[-1]C,12)=""STAB-PES-16-"",RIGHT(R5C:R[-1]C,3)+0,0)+1),""000"")", _
xlR1C1, xlA1, RelativeTo:=Cel)
Cel.Value = Cel.Value
End Sub