Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't delete named ranges?
I have found that you can only have one named range referring to a particular
range. You can add more, but they are not visible or editable in the sheets. So I am attempting to delete all the names on a worksheet prior to rebuilding them. I used: Dim theSheet As Worksheet Set theSheet = Worksheets("Input") For Each namedRange In theSheet.Names theSheet.Names(namedRange.Name).Delete Next namedRange When I use this, the code is skipped over as theSheet.Names is empty. However when I simply click around on the sheet I can see that there are names there. Does anyone know why this list appears empty even though there are ranges on the sheet? Maury |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete unnecessary Named Ranges | Excel Discussion (Misc queries) | |||
duplicate named ranges- how to detect, delete? | Excel Discussion (Misc queries) | |||
Delete all named ranges in a workbook | Excel Programming | |||
Delete named ranges beginning with a string | Excel Programming | |||
Delete LOCAL named ranges | Excel Programming |