Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Range Naming using Advanced Filter?
When I run Advanced Filter, Excel apparently automatically creates the new
rangenames "Criteria" and "Extract" for the associated ranges that are specified in the Criteria Range and Copy To portions of the dialog box. If I run the Advanced Filter a second time, specifying different ranges for Criteria Range and Copy To, I find that afterwards the range names "Criteria" and "Extract" have been moved to these new locations. Before I discovered this problem I had created the range names "Criteria" and "Extract" myself, using them in VB code, etc. I changed my names to something else, which seems to work around the problem. I cannot recall ever seeing a situation where Excel creates a range name without being asked to. Is this bizarre or what? Perhaps "Criteria" and "Extract" are key words that the user should not utilize for range names? Am I missing something? Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter using a range name as the criteria | Excel Worksheet Functions | |||
Advanced Filter - Automatic Update | Excel Worksheet Functions | |||
advanced filter a range | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Advanced Filter Range Selection in VB | Excel Programming |