Jayesh25

your code runs without error, but I still don't see the code highlighting the cells yellow when it finds a match. Just to clarify, in column A1:A500 i have tag names in the missing PI tags workbook. I want to search for those tags in the DB workbook in Column A1:A50000 and highlight the cells yellow when found.

Thanks for you guy's quick response. Very much appreciated