Listing Named Ranges
I vaguely remember a Q article with example code that generates a list of named ranges, if any, to a sheet. Cannot seem to find that article€¦
Appreciatively, Arturo |
Listing Named Ranges
On a new worksheet: InsertNamePaste, then click "PasteList" in the dialog.
You'll get a list of the NamedRanges, and their addresses, in the workbook. -- George Nicholson Remove 'Junk' from return address. "Arturo" wrote in message ... I vaguely remember a Q article with example code that generates a list of named ranges, if any, to a sheet. Cannot seem to find that article. Appreciatively, Arturo |
Listing Named Ranges
D'oh.
Thank you George. "George Nicholson" wrote: On a new worksheet: InsertNamePaste, then click "PasteList" in the dialog. You'll get a list of the NamedRanges, and their addresses, in the workbook. -- George Nicholson Remove 'Junk' from return address. "Arturo" wrote in message ... I vaguely remember a Q article with example code that generates a list of named ranges, if any, to a sheet. Cannot seem to find that article. Appreciatively, Arturo |
All times are GMT +1. The time now is 01:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com