Count Named ranges VBA code

**tarunpreet** · 10-08-2012, 02:40 PM

I want to count total named ranges in the excel workbook.

I am using this following code but this gives me list of all the named ranges. How can I get the absolute number of named ranges rather than list.

Sub List_All_Named_Ranges()

Selection.ListNames

End Sub

I will appreciate your help..

**mike7952** · 10-08-2012, 02:55 PM

This what your wanting

Please Login or Register  to view this content.

**stanleydgromjr** · 10-08-2012, 03:01 PM

tarunpreet,

Try:

Please Login or Register  to view this content.

**buran** · 10-08-2012, 03:10 PM

Note that names could refer no only to ranges, but also to functions or constants. if you really want to find only the names that refer to a range above code will give the correct number onlu when there are no names referring to number or function. If there are, you can use the following

Please Login or Register  to view this content.

**tarunpreet** · 10-09-2012, 10:15 AM

Thanks you!!

**buran** · 10-09-2012, 10:18 AM

Hi,
my impression was that you want only named ranges. That's why I post the code. If you want all names in the workbook the code provided by stanleydgromjr (post#3) will do the job

Buran

**stanleydgromjr** · 10-09-2012, 12:21 PM

tarunpreet,

You are very welcome. Glad we could help.

Come back anytime.

**sinkers** · 07-09-2019, 04:30 AM

Out of interest, it I wanted to delete all those named ranges (of functions and constants) what would the code be for that?

Thanks

**sinkers** · 07-09-2019, 04:31 AM

Originally Posted by buran

Note that names could refer no only to ranges, but also to functions or constants. if you really want to find only the names that refer to a range above code will give the correct number onlu when there are no names referring to number or function. If there are, you can use the following

Please Login or Register  to view this content.

Out of interest, it I wanted to delete all those named ranges (of functions and constants) what would the code be for that?

Thanks

**AliGW** · 07-09-2019, 04:32 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread