I have the below code , but it does not work. As an example if AA2 has "501D" as the value and D2 has a value of JonesCo/////ty501D.00 no match is found even though the string in AA2 contains 501D ? Any suggestions ?
IF .Range("AA" & intRow) Like "*" & .Range("D" & intRow) & "*" THEN
msgBox "Partial Match Found"