Hi All,
I have this code that allows me to search trough a list of items and it works great however some of those items contain two words and the filter doesn't
search for that is someone able to amend this code to use a contains filter please, Thanks in advance.
I have this code that allows me to search trough a list of items and it works great however some of those items contain two words and the filter doesn't
search for that is someone able to amend this code to use a contains filter please, Thanks in advance.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
'Updateby Extendoffice 20160606
Application.ScreenUpdating = False
Range("B10").Select
Selection.AutoFilter
Selection.AutoFilter
Range("B4").Select
If Target.Address = Range("B4").Address Then
Range("B11:i30000").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("B3:B4")
Application.ScreenUpdating = True
End If
End Sub