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. |
Losing a named range
This would likely be the result of the Named Cell being deleted. Either the
row, column, or the cell itself. HTH, Elkar "bluegrassstateworker" wrote: 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. |
Losing a named range
Hi,
You have to redefine those named ranges again. Challa Prabhu "bluegrassstateworker" wrote: 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. |
Losing a named range
On Aug 24, 3:36 pm, bluegrassstateworker
wrote: 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. My question is: under what conditions could this be happening? You are correct that I indeed do have to rename them. I wish to discontinue having to do this. |
All times are GMT +1. The time now is 02:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com