names of areas
 

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

thanks for your help

names of areas
 

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

names of areas
 

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

names of areas
 

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

names of areas
 

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

names of areas
 

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

names of areas
 

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