How to access entire named range count in a workbook?

The named ranges in a workbook is separated into two types based on their values. If value is a valid range, then it is known as known named range. If values is invalid range (i.e., #REF), then it is known as unknown named range. We have maintained two properties to return the count of named ranges with and without unknown named ranges.

To access the entire named range count, the INames object must be type-casted to WorkbookNamesCollection. Please refer the below code example to access the entire named range count in workbook.

C#

VB

The sample illustrating this behavior can be downloaded here.