| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM of areas | Excel Worksheet Functions | |||
| Excel 2007 defining names (areas) | Excel Worksheet Functions | |||
| Benifit of AREAS | Excel Worksheet Functions | |||
| re-ordering areas | Excel Programming | |||
| printing from different areas | Excel Worksheet Functions | |||
Threaded Mode
