Retrieving the Collection of Ranges in a Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Clarification: using Names on a worksheet gives only the named ranges
specific to that sheet (e.g. Sheet1!TEST1 vs Sheet2!TEST1) - it will not show
unqualified ranges that are defined for the entire workbook, even if they are
 
Not to waste anyones time with this, but what is the easiest way to get a
collection of ranges that are named in a workbook?

I have tried using Names but it seems to not show all named ranges.

Thanks in advance!

Regards
 
Yeah, I figured it out right after I posted, thanks for the info.

Regards,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting range names 3
Cell values to an array, then array transpose to another workbook 8
Creating a defined name's Refersto range 2
Post my named ranges in column A 10
range name define on non active(focused) sheet 10
Copying cells and formula from closed workbook to all sheets in open workbook 0
Advanced copying of range from one workbook to another 9
Get column name and data type from closed workbook 3

Back
Top