| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter input
Hi,
you could do something like: x = Sheets("Sheet1").Range("A1") Selection.AutoFilter Field:=1, Criteria1:=x Abdul Salam -----Original Message----- Hello, I have a question: Is it possible to autofilter based on a specific cell input? The line normally is: Selection.AutoFilter Field:=1, Criteria1:="ABC" However if I need BCD and this is located in Cell A1 you would could something like: Selection.AutoFilter Field:=1, Criteria1:="A1" or A1 However this doesn't work, does anybody know how it can work and also with the field chooser? Thank you very much, Hans . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter input
Dear Abdul,
It works! Thank you very much Kind regards, Hans -----Original Message----- Hi, you could do something like: x = Sheets("Sheet1").Range("A1") Selection.AutoFilter Field:=1, Criteria1:=x Abdul Salam -----Original Message----- Hello, I have a question: Is it possible to autofilter based on a specific cell input? The line normally is: Selection.AutoFilter Field:=1, Criteria1:="ABC" However if I need BCD and this is located in Cell A1 you would could something like: Selection.AutoFilter Field:=1, Criteria1:="A1" or A1 However this doesn't work, does anybody know how it can work and also with the field chooser? Thank you very much, Hans . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
| =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
Linear Mode
