Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions |