Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

List of defined names (ranges)

Posted by Fossie on June 12, 2001 1:56 AM

Hi,

Is there anybody who knows how to get a list of the Defined Names (ranges) specified in a certain Workbook. I need this to automate a task, but I don't know when I get the excelfile, how many ranges there are and the names of them.

I'm using Excel97 files.

I hope someone can help me solving this issue.

TIA,
Fossie

Re: List of defined names (ranges)

Posted by by on June 12, 2001 3:39 AM

Try 'F3' then paste link...
xBJ

ASAP Utilities

Posted by IML on June 12, 2001 11:19 AM

Check out the ASAP Utility. This option is under under information, list all range names

ASAP Utilities

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.