I have two ranges in the same workbook, one which is a static named range and one on a different worksheet that can have different dimensions. Each range contains values, not strings.

I want a macro that searches the two ranges and if one or more matches is found, displays a message in a specified cell in the worksheet with the unnamed range that says, "match found" .

thanks