need a createsheets macro that creates sheets based on a range

[dmcgov]

i have the following below for a button:

Please Login or Register  to view this content.

so what i need is the CreateSheets function, which right now only add's one page (sheet "B"). the sheet names start with A,B,C and go up to ZZZZZ (...X,Y,Z,AA,BB,CC...ZZ,AAA...ZZZZZ). I have all the sheets listed in a range (the formula's sheet, Column J, Row 19 to Row 148. i have a macro that loops through the sheets, left here so that you can see the functionality that I am looking for. note that Addfix is the variable that holds how many sheets are going to be created.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

how can i combine createsheets and dmcgov5 into one macro that adds the sheets based on the range that contains the sheets?
see the navigation sheet for the add, delete and manage buttons.
Create 1 - With Random Values.xlsm

[stnkynts]

FWIW - I started trying to dissect your post and the attached workbook. As I got deeper it started to become confusing to me and more of a hassle so I decided to abandon assisting with this post. Others might be going through the same thing. Best of luck.

[jaslake]

Hi dmcgov

As convoluted as your Code is, I do believe I know what it is you're trying to accomplish. Let me play a bit...probably won't be tonight.

[dmcgov]

thanks stnkynts, i appreciate the effort.

and thanks jaslake for going the extra mile. i look forward to what you have in mind.

some background.

the createsheets () function that i need has to do to things
1) start from 0 and add sheets
or
2) start from a value (1-130) and add sheets

the sheets need to be named A,B,C,etc. note that when you get to Z, it goes AA,BB,CC...ZZZZZ.

the rest of the routine works (as best as i could code it) so only need to make routine for adding sheets.

hope this helps.

[jaslake]

Hi dmcgov

In the attached I've added a Dynamic Named Range called "Exhibits"...

Please Login or Register  to view this content.

That Named Range is used in this section of Code...

Please Login or Register  to view this content.

The complete Code...

Please Login or Register  to view this content.

[dmcgov]

fantastic, one gold star for you. now let me add some functionality to the macro (need to populate a few cells with fixed data), might have another question but lets see how i fare. thanks again jaslake!!!

so here are the changes that i made to your routine (just copying data to cells) and it works like a champ

Please Login or Register  to view this content.

thanks again for all your help!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.