This project has moved and is read-only. For the latest updates, please go here.

Named Ranges on Workbook and Sheet Level

Apr 18, 2012 at 7:59 AM

I was a little bit confused exploring NamedRanges.

After a while debugging, I found out, that all named ranges are available at workbook level, while the named ranges collection on sheet level are always empty. In which cases a nemed range is visible at sheet level ?

Apr 18, 2012 at 5:04 PM

It all depends of the scope of the named ranges. By default the scope is workbook. See the documentation