Hello, I have a "template" worksheet that uses worksheet-scope named ranges. This template gets copied many times and the named ranges (their Names) copy along with it, and it works perfectly. My template has been deployed and copied > 100 times, but I now realize I would like to install an additional worksheet-scoped named range. What I would like to do is simply place that worksheet-scoped named range on my "template", then use conventional Excel copy-paste, selecting all the other worksheets at once, and pasting into the same destination. Unfortunately, it does not seem possible to paste the Name in this fashion. Is there a "paste special" or other trick that would make my Name paste onto the other sheets? My fallback plan is to use a throwaway VBA to do this, but it seems to be a general enough thing that Excel could do it.

Thank you for any help.