estatefinds
08-27-2016, 06:11 AM
I have data in the range from B2:I71 I need to run the macro to search in the data range V2:JX71 for the duplicates of the range B2:I71 and highlight them in the range V2:JX71.
The current CODE uses data in a column, but need the source data to be a range.
I am attaching a file for the example.
Thank you in advance for you help on this
also on the example youll see some cells colored red, this is for another macro disrgard these.
for this macro request I put the "10" for the color green to color the duplicate cells for this request.
thank you
The current CODE uses data in a column, but need the source data to be a range.
I am attaching a file for the example.
Thank you in advance for you help on this
also on the example youll see some cells colored red, this is for another macro disrgard these.
for this macro request I put the "10" for the color green to color the duplicate cells for this request.
thank you