![]()
Sub CreateSheets() Dim Count On Error Resume Next Application.DisplayAlerts = False Count = Application.InputBox _ (Prompt:="How many sheets do you want to insert?", _ Title:="HOW MANY?", Type:=1 + 8) On Error GoTo 0 Application.DisplayAlerts = True If IsNumeric(Count) And Count <> 0 Then Worksheets.Add Count:=Count, After:=Worksheets(Worksheets.Count) Else Exit Sub End If End Sub
Bookmarks