Partial cell(or string) match in excel macro

[AV114]

I am new to VBA and I would like to do a partial string (or cell) match between two sheets.

An example of

A	B	Result
'200001840036,'20812646883,'86414226	'20000812646883,'	Partially Matched with B
,'0650050010888	0650050010888	Partially Matched
'50200009667407	'50200009667407	Matched
20000812646883,'	'200001840036,'20812646883,'86414226	Partially Matched with A

Please help

 

[Marc L]

Start here (see in particular How to get the Best Results) :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

​

See also the VBA help of Range.Find method …​

​

 

[AV114]

not working

 

[p45cal]

I am new to VBA and I would like to do a partial string (or cell) match between two sheets.

An example of

A	B	Result
'200001840036,'20812646883,'86414226	'20000812646883,'	Partially Matched with B

Some partial matching is coloured red above; how long is the smallest number of contiguous characters needed that will count as a partial match? (Clearly, if it was only 1 then nearly everything woud be a partial match.)

 

[Marc L]

Last 9, maybe 10 in case of comparing the same row but not necessary if comparing from all worksheet …​

​

The reason why initial post must crystal clear explain the need ‼​

​