Excel "Named Range" Manager - To edit BOTH the Named Range - PLUS the VBA Code References to them?

[CrunchMasterMatt]

Hi,

I'm hoping for good news on this question...

Does anyone have a Named Range Manager Tool that changes the VBA Code at the same time as you change the Named Range in the workbook?

I have about 200 named ranges I have to edit, and I also have CODE attached to every one of them!!!!!! Agggghhhhhh.......... please help if you can.

Thank You!!!!!!!

 

[wigi]

AFAIK, there isn't such tool. The 2 sets of hardcoded elements are separated.
Editing one will not update the other. Ctrl-H within the entire VBA-project will be your best approach.