I am trying to find a way to simplify modifying Named ranges in Name Manager.
I can do this with this code:
Where I have a problem is that I have up to a dozen different ranges that I want to modify at different times, and rather than writing code for each Named Range, I would like to place the range info in another sheet for all named ranges, so that I can pull the desired range and swap it into the sub RedefinedNamedRange. The issue I am having is that if I place them on another sheet in a cell code such asPlease Login or Register to view this content.
and then try to reference it, it will change the Named range, but it places double quotation marks, making the range ineffective.Please Login or Register to view this content.
So instead of the Named range Refers To being
, I end up with this:Please Login or Register to view this content.
where the additional quotations occur rendering the code ineffective. I have been unsuccessful in finding a way to remove the quotation marks when trying to pull the code from another sheet.Please Login or Register to view this content.
Does anyone have any ideas or solutions?
Bookmarks