Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving the Collection of Ranges in a Workbook
Names is the property that is designed to give you all the named ranges. Can
you give some examples of where/how it is failing? The only thing I can think that might give a wrong result is if you are using Names on a worksheet object qualifier instead of the Workbook (if you did ActiveSheet.Names it would only give the names on the active worksheet, but ThisWorkbook.Names should give them all). "Adam" wrote: Not to waste anyones time with this, but what is the easiest way to get a collection of ranges that are named in a workbook? I have tried using Names but it seems to not show all named ranges. Thanks in advance! Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a collection into a new workbook. | Excel Discussion (Misc queries) | |||
Retrieving a Collection Item | Excel Programming | |||
Deleting named ranges by looping through range collection | Excel Programming | |||
Retrieving the sheet names of another workbook | Excel Programming | |||
How to find the type of Sheet in Excel.Workbook.sheets collection | Excel Programming |