Named Ranges on Workbook and Sheet Level

Apr 18, 2012 at 6: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 4:04 PM

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