vba macro to batch process adding worksheets

Hi Experts,


In need of your help as usual. I have a manually triggered code to manually create a new worksheet by manually entering the sheet name and the code checks for duplicates, copies master template sheet and renames it to newly entered name.

Now, I need a batch processing vba code to look at my names list in a range e.g A:A take each value, trigger my macro and enter the referenced name into it then letting the macro create a sheet and name it and then move on to the next name on the list.

This is my current macro code to add a new sheet:

Please Login or Register  to view this content.

Thanks in advance...

Maybe:

Please Login or Register  to view this content.

Many thanks JOHN H. DAVIS... your code worked a treat.... and I've customised it to my activity.

Just 1 more additional cry for help, how do I amend the code to first check if the sheet with the same name exists and if so skip the addition and move to the next. This is my code which is copying and renaming a master template:

Please Login or Register  to view this content.

Oh. I could also do with code to reverse this and batch search and delete sheets. I know I ask for too much but I'm a newbie to vba it may take me 3 hours to work out how to doe it when experts take 3-5 so your help is greatly appreciated.


Thanks in Advance..