Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named Range Question | New Users to Excel | |||
Named Range question | Excel Discussion (Misc queries) | |||
Named Range Question. | Excel Discussion (Misc queries) | |||
Named Range Question | Excel Worksheet Functions | |||
Named range question | Excel Discussion (Misc queries) |