On Jun 3, 3:42 am, AlbatroZ wrote:
Hi all,
I have a simple problem (i haven't touched a macro for ages),
On a a tab, I have a list of codes,
on another tab another list of code (very long). I would like to
highlight the codes in the second tab that matches the 1st one.

Thanks a lot in advance for your help

Can be done simply using conditional formatting,
Copy all the cells that you want to check and open the Conditional
Formatting window.
Use the 'formula is' option and then type in =countif([range],
[criteria])=0 choose the formatting you want and click ok.

Should highlight all the duplicates...