#1
|
|||
|
|||
Range Name in Adv Filter -> NOt working
Is it not possible to specify the range for the advanced filter via a Named Range? I have tried it when the range was a table, and when it was not. In both cases, I did not get an error, but it filtered out everything except the first row, which did not meet the criteria of the filter. |
#2
|
|||
|
|||
Hi 56_kruiser
Not that I am aware of, try here: http://office.microsoft.com/en-gb/ex...005200178.aspx |
#3
|
|||
|
|||
Well, I just have been having a brain fart. I just went in and tried again, and it works with range names, both for specifying the range, and the criteria.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Apply filter with VBA | bobsawyer7 | Outlook | 0 | 03-12-2012 04:02 AM |
filter | kwlickt | Excel | 1 | 03-28-2011 11:15 AM |
Select a range in one one workbook while working in other workbook | Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |
could you help me help me with advanced filter | Nora | Excel | 1 | 05-15-2009 11:10 AM |
junk email filter not working | michmurp | Outlook | 0 | 09-15-2008 10:57 AM |