Hi,

I would like to know the code to search through a range. If a single cell’s content in the range is the same as a cell within a range on another workbook, highlight the cell in green, and add one to an integer and display the total when the loop has finished.

Can anyone help with that?

Thanks