VBA Macro to find Duplicates using Ranges

Hi

VBA noob here, been searching for 2 days to find a script i can modify for my needs but keep getting stuck or not be able to make anything work for my specific situation.

I'm trying to write a simple but specific macro to find and color duplicates in ranges.

My search criteria is in Range(B5:B405) Data to be scanned and colored is located in Range(D5:OM1004)

The data is only numbers and needs to be an exact match to the search criteria, if cell in data is found to exist in search criteria then data cell is filled red.

I also need to stop the script at data row 1004 and display a message with total execution time at the end.

I can do this in seconds with Conditional Formatting but I need to count the colored cells after and no VBA Macros i can find will let me count conditionally formatted colors, even been through all of cpearson's site without success.


Working Code is here, i hope this helps someone in the future.

Please Login or Register  to view this content.

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.