Find Multiple Criteria with Wildcard

hi,

Below is code which I am using to find multiple criteria offset and place different cell value. But I need to search with wildcard criteria. How I can amend the code to get the result.

Please Login or Register  to view this content.

Give an example of the data in which you search with this code (the data should be false to protect privacy and confidentiality).

Thanks, the code working without wildcard but I need to search with the wildcard.

hi,

can someone please help me to solve this thread.

Another option

Please Login or Register  to view this content.

@Bo_Ry and @Fluff13,

Excellent, works perfectly. Thanks for the wonderful solution.

You're welcome & thanks for the feedback.

@ Fluff13,

Can I request few changes in the code, if there is nothing to find in the range I need to ignore and proceed only if it finds the string mentioned in the vFINDs and replace only vVALUs mentioned in the replace string.

Excellent... Thanks for your amazing solution.

My pleasure.