We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

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.

 

Property

Description

INames.Count

Returns the count of the known named range.

WorkbookNamesCollection.Count

Returns the count of the named range including unknown named range.

 

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.

 

Article ID: Published Date: Last Revised Date: Platform: Control:
5533 10/30/2015 10/30/2015 Windows Forms XlsIO
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.