How to use wild card in VBA for Advance Filter?

LearnerExcel · #1 10-06-2017, 03:45 PM

I have the following VBA Code which filters data but if I type starting text in excel search field. It doesn't filter date if it is from the middle of the cell.

For Example, Cell B7 Contains text "Starting Data File & Middle File" and when I type in Cell B2 (Search Criteria Cell) "Starting" it shows the result. But if I type "Middle File" it won't show any records. How can I resolve this issue? How to use the wildcard here in VBA?

Code:

Sub SearchMe()
' SearchMe Macro
    Range("B5:J1000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
        Range("ComparisonFilterInPlace!B2:J3"), Unique:=False
End Sub

Debaser · #2 10-09-2017, 12:27 AM

If you want records that end in "Middle File", use "*Middle file" in the cell (without the quotes). Or for contains Middle File, use "*Middle file*".

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find with wild cards and add into CC	sylvio	Word VBA	2	09-04-2017 01:00 AM
ID Card Template	Jenna Deakin	Word	0	08-09-2017 06:36 AM
Filter Mail Merge based on a list of filter criteria	AusSteelMan	Mail Merge	2	05-09-2016 03:35 PM
Question about find and replace wild cards	catherineliang	Word	1	07-21-2014 09:42 PM
Wild card to highlight capitalised terms?	bertietheblue	Word	2	02-08-2013 04:44 PM