Thisworkbook.names.count shows one extra range

[ImranBhatti]

Hi

In the attached workbook. I have only thirty named ranges Also shown Sheet1. But in the immediate window the answer of ?ThisworkBook.Names.counts shows 31.Are all the named ranges weather created from the named manager or by selecting a range ,typing a name in Namebox on top of A1 and hitting Enter, are shown in the name Manger (I don't remember I create a named range with the later method).

Thanks in advance


Best Regards
Imran Bhatti

[Zer0Cool]

Likely a hidden/invisible named range.

Ill take a peak at the file

EDIT: your hidden name is called "Notes!_FilterDatabase". You can try deleting it via VBA if its not needed.

EDIT2: I was able to delete it via VBA. I looped the names collection and put an If n.name = "Notes!_FilterDatabase" then followed by an n.delete. In this case I declared n as a name earlier in the code and used a for loop to loop each n in Names.

[fshbet]

Hi ImranBhatti,

The reason for extra name range is due to 'Notes!_FilterDatabase'.

Please Login or Register  to view this content.

Use this code to view all the names in a workbook.

[ImranBhatti]

Thanks both of you.
I did received this file from the dropbox of one of my client. Can you please tell or even better direct me to some resource about this problem.
I think this is something that can be manipulated other ways.


Thanks again.

Best Regards
Imran Bhatti

[xlnitwit]

It is a name that is created automatically by Excel when applying filters to a range. Why does it matter to your code?

[ImranBhatti]

Thanks xlnitwit

The reason it matters is because I need to use the count of NamedRanges in the code. Is confirmed that filtering data will create only one named range. coz at the moment Or repharase the question . will the filter create the named range always with this name (Mysheetname_FilterDatabase). I think I should mark my thread Unsolved.

Problem is solved but only for this book and not generally. It does not mean by any mean that the solution by fshbet and zerocool is not appreciated.

[xlnitwit]

My question is why does it matter? It would be extremely time consuming to write code to eliminate every possible unexpected name. If you are only interested in specific names, do they have an attribute that you can check- for example, are you only interested in visible names? If so, simply test the Visible property inside your loop before doing anything with the Name.

[ImranBhatti]

Well pointed xlnitwit .It solved my problem now really.

?thisworkbook.Names(i).Visible

Never needed to check this property of named range before.

Many thanks indeed.