Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 10-06-2017, 03:45 PM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
Join Date: Nov 2016
Posts: 67
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to use wild card in VBA for Advance Filter?

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?

Sub SearchMe()
' SearchMe Macro
    Range("B5:J1000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
        Range("ComparisonFilterInPlace!B2:J3"), Unique:=False
End Sub
Reply With Quote
Old 10-09-2017, 12:27 AM
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Posts: 154
Debaser is on a distinguished road

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*".
Reply With Quote

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 04:36 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft