| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reapply filter
Is there a way to reapply a filter automatically?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reapply filter
See this example:
http://www.rondebruin.nl/copy5.htm#Add I think you need something such as: 'Filter the range rng.AutoFilter Field:=FieldNum, Criteria1:="=" & cell.Value 'etc., etc., etc., etc., etc., 'Close AutoFilter ws1.AutoFilterMode = False Experiment with the macro recorder too!! Regards, Ryan--- -- RyGuy "Choose Top 3 Automatically" wrote: Is there a way to reapply a filter automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reapply cell gridlines after removing background color | New Users to Excel | |||
| Storing Formats of cells in Array and reapply later | Excel Programming | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| How to save & reapply a set of excel filters after clear | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
![Choose Top 3 Automatically[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
