Naming new sheets with an input box with a dynamic text string in the prompt

[Ianmacros]

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:

Please Login or Register  to view this content.

[spencer_time]

The way many computers(programs) count, starts at zero. You might try changing the following:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I suspect that the "first" element is element 0, "second" is element 1, etc...

EDIT:14:37
Also do the same to the next part:

Please Login or Register  to view this content.

change to

Please Login or Register  to view this content.

[Rick Rothstein]

Arrays produced by the Array function start at index 0, not 1 by default. So, you could either subtract 1 from the index value for calls to the ShtCount array or you could put this at the top of your code window to force the Array function to start at index 1...

Option Base 1

[jolivanes]

spencer_time nailed it right on.
If you want to start with 1 being the first item, you need to use "Option Base 1" at the top of your code window.
https://docs.microsoft.com/en-us/off...base-statement

[Ianmacros]

Thank you! I did not know that and didn't know I could use the Option Base 1. You guys are awesome!

[Rick Rothstein]

Thank you! I did not know that and didn't know I could use the Option Base 1. You guys are awesome!

One note about Option Base 1... it does not work for an array produced by the Split function... the Split function always returns a zero-based array independent of the Option Base setting.