G
Guest
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
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