Range Names

[Chris Gorham]

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