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 |
All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com