Sub numera() Dim prev() Dim sh As Worksheet ReDim Preserve prev(Worksheets.Count) Max = 0 For i = 1 To Worksheets.Count prev(i) = Split(Worksheets(i).Name, "21-10") 'fino a 100 usare ->21-0 dopo 21-10 On Error Resume Next If prev(i)(1) > Max Then Max = prev(i)(1) On Error GoTo 0 Next i Max = Max + 1 Worksheets("master (2)").Name = "21-10" & Max 'fino a 100 usare ->21-0 dopo 21-10 Call EstraiNomeFoglio End Sub
............... prev(i) = Split(Worksheets(i).Name, "21-0") ............ Max = Max + 1 Worksheets("master (2)").Name = "21-0" & Max .............
............... prev(i) = Split(Worksheets(i).Name, "21-10") ............ Max = Max + 1 Worksheets("master (2)").Name = "21-10" & Max .............