Name automaticly defined

[Evolta]

I select some data from 4 cells. Based on that selection I fill up a sheet with data from another bigger datasheet.
Now I noticed that it calls one cell: "Extract" and I have no idea where I wrote that in the code. (I have used some coding from others, but can't find anything).

Any idea how this can happen?

Sorry for this vague question, but I can't really tell it any better then I just did.
It bothers me because when I try to use advancedfilter it doesn't see that Extract cell as Unique with the other cell with the same value.
If I later ask if cell Extract = other cell it returns TRUE.

So i think its a weird thing, not critical, but just weird.

[Leon V (AW)]

Can you post the code?
by "calls one cell: "Extract"" do you mean it is a named range?

[TMS]

"Extract" is an automatically generated Named Range used when you use an Advanced Filter to copy to another range. You may also see one named "Criteria".


Regards, TMS

[Evolta]

"Extract" is an automatically generated Named Range used when you use an Advanced Filter to copy to another range. You may also see one named "Criteria".

Regards, TMS

Is it possible to turn this auto-naming thing off?

[Leon V (AW)]

you could just delete it as soon as it is created

Please Login or Register  to view this content.

[Evolta]

Will do
Is there any good reason why this is done? (automatically name it Extract or Criteria)

[TMS]

I guess the extract process needs to know where to get stuff from and where to put it and it creates Named Ranges to refer to those locations.

You can delete them if you wish, but why worry? They're not doing any harm, are they?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Evolta]

I guess the extract process needs to know where to get stuff from and where to put it and it creates Named Ranges to refer to those locations.

You can delete them if you wish, but why worry? They're not doing any harm, are they?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Wanted to wait a little to maybe find out why this is done. Just out of curiosity.
But I won't bother anyone anymore, I'll mark it solved.

Thanks all for explaining where this comes from.

[TMS]

John Walkenbach
The Spreadsheet Page
Excel Developer Tip

http://j-walk.com/ss/excel/tips/tip88.htm

Clearing the Advanced Filter Dialog Box

When you choose the Data, Filter, Advanced Filter command, Excel displays its Advanced Filter dialog box. You've probably noticed that Excel "remembers" the previous range specifications for the List range, Criteria range, and Copy to range. In most cases, this is useful. But if you're working with several different worksheet databases, you may prefer that Excel uses the current database rather than the previous database.

There is no direct way to clear the previous settings from the Advanced Filter dialog box. However, you can use the simple VBA procedure listed below.

Please Login or Register  to view this content.

How it works

Excel keeps track of the previous Advanced Filter range specifications by using three name: _FilterDatabase, Criteria, and Extract. The ShowAdvancedFilterDialog procedure simply deletes these names, and then uses the Show method to display the Advanced Filter dialog box. Because these names are not defined, it's as if you are using the Advanced Filter command for the first time.

Note: The _FilterDatabase name is a hidden name. Therefore, the only way to delete it is by using VBA code. The Criteria and the Extract names are normal names, and can be deleted using the standard Define Name dialog box.

Using the procedures

To use this procedure, copy it and paste it to a VBA module in your workbook. Then, execute the ShowAdvancedFilterDialog macro instead of the Data, Filter, Advanced Filter command.