Code to un-filter ...

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Code to un-filter ...

FAQ

Thread Tools

Display Modes

03-07-2018, 11:23 PM

LearnerExcel LearnerExcel is offline

Windows 7 32bit Code to un-filter ...

Office 2013

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 PM.