Sub NEWblmobile()
Dim n, k, tx, onglet, deb, init, nb
init = "RE" ' les 2 premiere lettre du dernier onglet
nb = 4 'nombre d'onglet ? copier
ActiveWorkbook.Unprotect ""
For k = Sheets.Count To 1 Step -1
If Left(Sheets(k).Name, 2) = init Then
deb = k
n = Val(Replace(Sheets(k).Name, init, ""))
tx = Replace(Sheets(k).Name, n, n + 1)
Exit For
End If
Next
For k = deb - nb + 1 To deb
Sheets(k).Copy after:=Sheets(Sheets.Count)
tx = Replace(Sheets(k).Name, n, n + 1)
ActiveSheet.Name = tx
'If Left(tx, 2) <> "BL" Then
'ActiveSheet.Unprotect
' ici c'est pour modifier les formules
'For Each c In ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas)
'c.Formula = Replace(c.Formula, "BL impr." & n, "BL impr." & n + 1)
'c.Formula = Replace(c.Formula, "Man" & n, "Man" & n + 1)
'Next
'End If
Next
ActiveWorkbook.Protect ""
End Sub