Named Ranges

[ddmmyyyy]

Hi - I know what they are etc...
Just wondering where they're stored in Excel etc ?
Also, what happens when they go corrupt ?
Thanks!

PS - this is handy - prints a list of all named ranges in a workbook!
Private Test()
Range("A:B").ClearContents
Range("A1").Select
Selection.ListNames
End Sub

Thks!
ddmmyyy

 

[Charles Williams]

They are stored in the Names collection.

If they are corrupt you should delete them

If you are working with Names try downloading Name manager from
http://www.decisionModels.com/downloads.htm


--
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com