Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving the Collection of Ranges in a Workbook
Clarification: using Names on a worksheet gives only the named ranges
specific to that sheet (e.g. Sheet1!TEST1 vs Sheet2!TEST1) - it will not show unqualified ranges that are defined for the entire workbook, even if they are on that worksheet. "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 the Collection of Ranges in a Workbook | Excel Programming | |||
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 |