ActiveWorkbook.Worksheets.Name - Apllication-defined or object-defined error

Hi folks.
This is my first post, relalatively new to vba, i'm trying to write a little program that creates sheets from an user box.
So the user puts the quantity of sheets to be created (ex.-3), then i would like to have 3 new sheets and these sheets renamed with 1, 2, 3 etc
Works without problem but have a problem when it tries to rename the new worksheets from the array values.
Therefore if i have an hard coded array i have no problems to rename from these values...

Please Login or Register  to view this content.

Here is my code..

Please Login or Register  to view this content.

I get an 1004 error "Apllication-defined or object-defined error" at this part.

Please Login or Register  to view this content.

If i could have a friendly hand on my code, and maybe some explanations :-) Really would appreciate, i'm getting a bit stucked on it, really i don't see where i'm false...

If you are "new to vba: and wrote this code that is very impressive. The With statement that you used is solid. The problem is with the "theArr(sht)" part. Correct me if I am wrong but don't you want the name of the sheet to be what was entered into the input box? If that is the case why not just use

Please Login or Register  to view this content.

Originally Posted by stnkynts

If you are "new to vba: and wrote this code that is very impressive. The With statement that you used is solid. The problem is with the "theArr(sht)" part. Correct me if I am wrong but don't you want the name of the sheet to be what was entered into the input box? If that is the case why not just use

Please Login or Register  to view this content.

Thank you, you're nice fella with my code, but really i've got written vba (or try to understand it) from 3 months, and sometimes what you see from some coders, it's really impressive, and certainly my code, is somewhat, but thank you, really.
And yes i would rename my recently created sheets with the "names" of the array values...

Originally Posted by HaHoBe

Hi, CLIOWIWI,

the array you refer to is redimmed but empty - you should use sht to give the sheet a name:

Please Login or Register  to view this content.

And fine art of indenting wouldn´t help with this problem but make the code a lot more readable:

Please Login or Register  to view this content.

Ciao,
Holger

You are totally right, i must to take some good coding resolutions to have less problems..
I Have already tried you're solution, it works indeed, but one of my goals in my program was also, if sheets exists already do not create them, and no error on another execution on the same sheet..

Please Login or Register  to view this content.

certainly i don't understand the difference between

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thank you lot for give me some time!

Thank You a lot! Works perfectly!