R
Ray Batig
Greetings,
I need some advice on this approach before I try it. I have a workbook with
nearly 100 named ranges. As the workbook is used, most of the named ranges
grow using resize. While testing during development, I have been using the
Insert > Name > Define route to reset the ranges to the starting values.
What I am thinking of doing is to paste a Named Range list onto a blank
worksheet for reference and then writing code ( good reference at Chip
Pearson's site - Thanks Chip ) to delete all the Named Ranges and then Add
them back based on the list.
Are there any known problems with this approach before I try it and end up
sorry?
Thanks in advance for your guidance!
Ray
I need some advice on this approach before I try it. I have a workbook with
nearly 100 named ranges. As the workbook is used, most of the named ranges
grow using resize. While testing during development, I have been using the
Insert > Name > Define route to reset the ranges to the starting values.
What I am thinking of doing is to paste a Named Range list onto a blank
worksheet for reference and then writing code ( good reference at Chip
Pearson's site - Thanks Chip ) to delete all the Named Ranges and then Add
them back based on the list.
Are there any known problems with this approach before I try it and end up
sorry?
Thanks in advance for your guidance!
Ray