Names of named ranges in active sheet only
 

Hi XP,

When working with names, you should not be without Jan Karel
Pieterse's invaluable NameManager addin which may be downloaded,
free of charge, at:

http://www.jkp-ads.com/Download.asp


---
Regards,
Norman



"XP" wrote in message
...
In Excel 2003, is it possible to return only the Names of named ranges in
the
active sheet vs. the entire workbook?

Could someone please post example code on how to do this?

Must the range be named a certain way for the code to detect this info?

Thanks.