Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Losing a named range
I have a spreadsheet used as a form that uses name ranges. I have
found a situation where a user has somehow deleted or removed a name range. When I go into the named range, there is a reference error to the range. The range is only one cell. This poses a problem since a macro uses the named range when the spreadsheet is saved. Other than backspacing the named range in the formula bar is there any other likely scenario that could result in inadvertant removal of this named range. If I can figure out what they might be doing, I can programmatically prevent them from doing so. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Dynamic range chart losing its dynamism..?? | Charts and Charting in Excel | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |