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 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

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