yeah, I know about that drop-down list but I'm actually looking for a display
of all named cells at once...
Somebody posted a macro, I may try that out...
Any other ideas?

"Rick Rothstein (MVP - VB)" wrote:

Is there a way to visually show on the spreadsheet which cells have been
named and what the names are? Something like a coloured border around the
cells and the name displayed like a comment box? I don't actually need it
in
this particular format but would just like to see where my named cells are
so
I can edit them if I see errors.

In the "names" field on the left of the formula bar, there is a drop-down
arrow... click it and select the range name from the list which will
highlight the cells it is composed of.

Rick