Named Range Question
Thanks I will give it a try.
Nigel wrote in message
...
I use a similar technique to reset an application, I have not encountered
any problems so far!
Cheers
Nigel
"Ray Batig" wrote in message
ink.net...
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
|