Range Names
Hi,
I asked for some code to allow me to cycle through the Range Names in a Workbook in alphabetical order. With ActiveWorkbook.Names For N = 1 To .count rng_name = .Item(N).Name Next N End with This works, but there is a problem... There is a trick (I've forgotten how) where the define / range name menu allows you to have the sheet name, which contains the range being created, appearing to the right of it in the dialog box. This sheet name appears as part of the range name when you use the macro code above, thus ensuring that the order is nonalphabetical. Any help appreciated Chris |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com