how to display the referral area of a name
 

Is it possible to view all areas for all names at once?

how to display the referral area of a name
 

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




--
Gary''s Student
gsnu200707


"Holly" wrote:

Is it possible to view all areas for all names at once?