Hello,
I have a spreadsheet with 3 tables which are named. These are displayed in the Formulas tab of the ribbon in Excel 2010, in the Name Manager. However, in addition to those three, another range name is displayed in the Name Box. There was unreadable information in this spreadsheet when I opened it this morning which Excel repaired. I think that is why this name is there.
The range is not needed and does not appear to really refer to any cells. That is, when I select it in the Name Box, no range is selected. How do I get rid of it? I tried Range("Actions4").delete which did not work.
-- removed inline image ---
-- removed inline image ---
I have a spreadsheet with 3 tables which are named. These are displayed in the Formulas tab of the ribbon in Excel 2010, in the Name Manager. However, in addition to those three, another range name is displayed in the Name Box. There was unreadable information in this spreadsheet when I opened it this morning which Excel repaired. I think that is why this name is there.
The range is not needed and does not appear to really refer to any cells. That is, when I select it in the Name Box, no range is selected. How do I get rid of it? I tried Range("Actions4").delete which did not work.
-- removed inline image ---
-- removed inline image ---
Last edited: