I would like the below code to work as intended. At the moment it inserts "second", "third", etc. into the WsName prompt (e.g. What's the name of the second sheet?). I can't figure out why it is skipping the first member of the ShtCount array ("first").
Here is the code:
Dim intSheets As Long
Dim newName As String
Dim ShtCount
ShtCount = Array("first", "second", "third", "fourth", "fifth", "sixth", "seventh", "eight", "ninth", "tenth")
intSheets = InputBox("How many sheets would you like to include in the Dashboard?")
Worksheets.Add Before:=Sheet1, Count:=intSheets
For i = 1 To intSheets
Sheets(i).Activate
WsName = InputBox("What's the name of the " & ShtCount(i) & " sheet?")
ActiveSheet.Name = WsName
Next
Bookmarks