VBA search on cell value with wildcard

[Dave8899]

Hi hope someone can help I have a vba that is working really well but i need to modify it slightly, currently it’s searching dependent on the value of a cell,

 searchvalue = reportsheet.Range (”C2”) .Value

this works fine if the content in “C2” is exactly right, but I’m using for ref numbers and they are long and complex is there a way to add a wild card or something so the vba will search for all matches, for example :

If C2 was 357, the vba would pick up 357, 2357, 3579, etc.

hope I’ve explained this enough if you want or need more let Me know

many thanks

dave8899

 

[Anthony47]

What is important is not the way you set the value for variable "searchvalue" but how you compare the target values with searchvalue, that you didn't show us.
So I can suggest that you use not (for example) If Something = searchvalue Then but use operator Like
For example:

If Something Like "*" & searchvalue & "*" Then

For the description of Like: Like operator


Or you might use the function InStr; for example:

If InStr(1, Something, searchstring, vbTextCompare) > 0 Then

For the description of InStr: InStr function (Visual Basic for Applications)

If these suggestions don't help, then share the relavant part of your code

Bye

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VBA search on cell value with wildcard
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.