VBA to highlight/unhighlight duplicates accross many sheets

[Lsxtrkiller]

I am trying to develop a code to highlight duplicates across multiple sheets I have thus far been unsuccessful I found an example using cell addresses online and came up with the following and this works IF the duplicate values are in the same cell IE sheet 1 A1 and sheet 2 A1... What I need however is a macro that will do the same thing to highlight and unhighlight based on duplicates found anywhere in the workbook. workbook in question has about 150 worksheets to look through. Please let me know what you guys can come up with.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[mikerickson]

That is looking through A1:AH1000, I presume that is for every sheet

Do you want
"things in Sheet1 that are on all other sheets"
"things in Sheet1 that are on any other sheet"
"things on any sheet that are also on any different sheet"

If one of the first two options, do you want only the cell in sheet1 highlited or both sheet1 and the cell in the other sheet?

Also is it all the sheets in the workbook or only most of them?

[mikerickson]

duplicate post

[Lsxtrkiller]

I want to highlight "Things on any sheet that are also on any different sheet"

All sheets. Also the correct range I would like it to check would be AB3:AL150. If there is a duplicate I would like it highlighted on all sheets.

Thanks for the reply.

[mikerickson]

I think this might do what you want.

Please Login or Register  to view this content.

[Lsxtrkiller]

This looks amazing. So far no issues its doing what I wanted. It takes longer to run than I was hoping but its ALOT of cells to check so I guess its so be expected.

Thank you so much.