Hi everyone,
I adapted this macro that allows me to highlight duplicates in column A of every sheet in my workbook. There are 5 sheets. When I press F8 and have the sheet open, the macro successfully highlights the duplicates. However, when I run F5, it does not work, or sometimes only works...