Try this...
![]()
Sub Macro2() With Sheets("Info").Range("Device_Description_1").Cells(1) If .Value <> "" Then Range("$A$1:$N$221337").AutoFilter Field:=3, Criteria1:="=*" & .Value & "*" End If End With End Sub
Try this...
![]()
Sub Macro2() With Sheets("Info").Range("Device_Description_1").Cells(1) If .Value <> "" Then Range("$A$1:$N$221337").AutoFilter Field:=3, Criteria1:="=*" & .Value & "*" End If End With End Sub
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks