Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to unfilter one field only
Here is my code:
Sheets("CEU Database").Select If Sheets("Code").Range("L2").Value = "All" Then '??? I need to unfilter Field: 1 only, and leave all other filtered fields intact Else Cells.Select Selection.AutoFilter Field:=1, Criteria1:=Sheets("Code").Range("L2").Value End If |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to unfilter one field only
AFAIK you will have to unfilter all and re-apply a suitable filter.
-- Don Guillett SalesAid Software "scrabtree23" wrote in message ... Here is my code: Sheets("CEU Database").Select If Sheets("Code").Range("L2").Value = "All" Then '??? I need to unfilter Field: 1 only, and leave all other filtered fields intact Else Cells.Select Selection.AutoFilter Field:=1, Criteria1:=Sheets("Code").Range("L2").Value End If |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to unfilter one field only
I put a little data on a worksheet.
I applied data|filter to that data. I filtered by both column 1 and column 2. Then I turned on the macro recorder when I did "(All)" for the first field. I got this back: Selection.AutoFilter Field:=1 scrabtree23 wrote: Here is my code: Sheets("CEU Database").Select If Sheets("Code").Range("L2").Value = "All" Then '??? I need to unfilter Field: 1 only, and leave all other filtered fields intact Else Cells.Select Selection.AutoFilter Field:=1, Criteria1:=Sheets("Code").Range("L2").Value End If -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code for empty txt field | Excel Discussion (Misc queries) | |||
unfilter | Excel Discussion (Misc queries) | |||
Code to include a one-up suffix to a field value | Excel Discussion (Misc queries) | |||
Code to include a one-up suffix to a field value | Excel Worksheet Functions | |||
Unfilter | Excel Programming |