#1
|
|||
|
|||
Code to un-filter ...
The following code works for filtering data. But what is the code to un-filter it.
Code:
Private Sub Worksheet_Change(ByVal Target As Range) 'Updateby Extendoffice 20160606 If Target.Address = Range("M2").Address Then Range("A3:M700").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("M1:M2") End If End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to modify code for Auto filter based on two criteria ... | LearnerExcel | Excel Programming | 13 | 02-14-2018 08:20 PM |
VBA Code to search for field codes with certain text before the Field code and to change style | welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
VBA Filter | SavGDK | Excel Programming | 2 | 10-14-2016 11:37 AM |
Filter Mail Merge based on a list of filter criteria | AusSteelMan | Mail Merge | 2 | 05-09-2016 03:35 PM |
filter | kwlickt | Excel | 1 | 03-28-2011 11:15 AM |