If the Named Areas are all one one sheet, then:
Sub show_all()
Dim r As Range
Set r = Nothing
For Each n In ActiveWorkbook.Names
If r Is Nothing Then
Set r = Range(n)
Else
Set r = Union(r, Range(n))
End If
Next
r.Select
End Sub
will display all at once.
Macros are very easy to install and use:
1. CNTRL-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE window
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
