how to Create multiple worksheet based on cell value!!!

**eddie_1** · 01-31-2009, 09:34 AM

hi can some plz help with vb code/macro for the following function.

Basically i want to create X number of worksheets and then give them names A,B,C,D,E,G.....and soo on. The number of worksheets i.e X is a variable cell value from another sheet e.g. on sheet1 value of X is lets just say 6. i will then need to create six new sheets named A,B,C,D,E,F

can anyone please help me i would greatly appreaciate your help.

**DonkeyOte** · 01-31-2009, 09:55 AM

Perhaps:

Please Login or Register  to view this content.

You will get errors if you try and re-run the routine... ie recreate 'A' if it already exists... you don't specify what you would want to do were this to occur.

**DonkeyOte** · 01-31-2009, 10:11 AM

As per the other forum please ensure you publish other links should you choose to x-post in other forums:

http://www.mrexcel.com/forum/showthread.php?t=368020

**davesexcel** · 01-31-2009, 10:38 AM

Try this to start

Please Login or Register  to view this content.

**DonkeyOte** · 01-31-2009, 10:44 AM

Chr64 method is flawed if you add > 26 sheets.... far better to use Address approach IMO.

On an aside it is my understanding that Integer type is converted to Long under the hood in 32-bit VBA so is a moot type (only really useful if you intend to use as a sanity check... ie to generate overflow else you're better off using Long... obviously Byte etc if possible)