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)