Simon Lloyd
05-26-2008, 02:51 AM
Hi All, Lately i have been using Advanced Filter alot both at worksheet level and in code and i have just noticed (yeah observant 'aint I?) that when this action is performed Excel creates a named range called Extract but it's only for the destination cell of the filtered list any ideas why?
Also if you the perform the action again to another location it redefines the named range any ideas how this is performed? I am just interested to know if it's possible to work with this inbuilt feature in VBA for referencing Extract but referring to the entire copied range (just makes your code neater and shorter if referring to named ranges).
I have also noticed that you can reference that named range in a cell using =EXTRACT but of course only gives you the result of the single cell.
Also if you the perform the action again to another location it redefines the named range any ideas how this is performed? I am just interested to know if it's possible to work with this inbuilt feature in VBA for referencing Extract but referring to the entire copied range (just makes your code neater and shorter if referring to named ranges).
I have also noticed that you can reference that named range in a cell using =EXTRACT but of course only gives you the result of the single cell.