I have a worksheet that contains some areas and I need to find out their
names

thanks for your help

See how you can find the names that ranges use by using the Name box. It's
described he
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Buddy Lee" wrote in message
...
I have a worksheet that contains some areas and I need to find out their
names

thanks for your help

Dim nme As Name

For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name & ", " & nme.RefersTo
Next nme


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buddy Lee" wrote in message
...
I have a worksheet that contains some areas and I need to find out their
names

thanks for your help

If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Buddy Lee wrote:

I have a worksheet that contains some areas and I need to find out their
names

thanks for your help

--

Dave Peterson

that's great, however, is it possible to get names from an unactive sheet?
e.g. "sheet1"
worksheets("sheet1") does not have a property Names


"Bob Phillips" pí¹e v diskusním
pøíspìvku ...
Dim nme As Name

For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name & ", " & nme.RefersTo
Next nme


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buddy Lee" wrote in message
...
I have a worksheet that contains some areas and I need to find out their
names

thanks for your help

i mean only from 1 sheet :)

--

icq 25372592
"Buddy Lee" pí¹e v diskusním pøíspìvku
...
that's great, however, is it possible to get names from an unactive sheet?
e.g. "sheet1"
worksheets("sheet1") does not have a property Names


"Bob Phillips" pí¹e v diskusním
pøíspìvku ...
Dim nme As Name

For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name & ", " & nme.RefersTo
Next nme


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buddy Lee" wrote in message
...
I have a worksheet that contains some areas and I need to find out their
names

thanks for your help

done :)

--

icq 25372592
"Buddy Lee" pí¹e v diskusním pøíspìvku
...
i mean only from 1 sheet :)

--

icq 25372592
"Buddy Lee" pí¹e v diskusním pøíspìvku
...
that's great, however, is it possible to get names from an unactive
sheet? e.g. "sheet1"
worksheets("sheet1") does not have a property Names


"Bob Phillips" pí¹e v diskusním
pøíspìvku ...
Dim nme As Name

For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name & ", " & nme.RefersTo
Next nme


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buddy Lee" wrote in message
...
I have a worksheet that contains some areas and I need to find out
their
names

thanks for your help