How to add a new sheet using VBA?

In sheet1 cell (A2), i have to enter a number and that number would create the number of new sheets.

Eg. if i enter a 4 on (A2), 4 new spreadsheets are being created.

how do i do it? Need some urgent help here.. thanks

If you mean worksheets and not spreadsheets try something like :

Please Login or Register  to view this content.

Originally Posted by Steel Monkey

If you mean worksheets and not spreadsheets try something like :

Please Login or Register  to view this content.

I have tried your coding and it works but how to not let the number in A2 disappear? I want the number to stay there and how to make it run automatically?

Eg. I no need to click on the run button in order for it to run but just by typing any number on A2 and it will generate itself

Insert this into the Sheet1 module

Please Login or Register  to view this content.

Let me know how you go!

Originally Posted by Steel Monkey

Insert this into the Sheet1 module

Please Login or Register  to view this content.

Let me know how you go!

hmm.. can you help me do it on excel and send me the attachment file so that i can understand it better.

Thanks

Please see attached spreadsheet

Any questions let me know!

Please note rule 4 to posting:
4). If you post the same question to other sites as well, please provide a link to that post so that it would be checked that if your post has already been answered.

cross posted on ozgrid and mrexcel