Add Sheet and rename based on defined range

  • Hi All,


    New to VBA and gone through a lot of researching and found a useful code for my need. Here is my issue:


    Adding sheet and renaming based on predefined range works fine except for this:


    1. named cell - 10, 20 and 30 doesn't give me a new sheet with those names


    Anything that is names with above doesn't create a new sheet with those names, for some it get skipped.


    Here is the code I gathered from different sources and i cannot remember all those built these: (added some to fit my specific needs)



    THANKS FOR THE HELP!