PDA

View Full Version : [SOLVED] Need help rearranging VBA to search from a rangei a range for duplicates to HL please



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

SamT
08-27-2016, 09:36 AM
How about you post the original code you want edited.
Then you post the code the way you think it should be.



You have been here long enough to start learning VBA and stop using us as your Free IT department.

We are very happy to help those who help themselves, especially happy to help them learn VBA.

estatefinds
08-27-2016, 09:50 AM
i was just clarifying to avoid confusion as to why the cells were red.


I am trying to learn VBA its not easy for me.

I have been learning how to edit lines in VBA but do occaissionaly get stuck.

with this code I actually figured it out using;

Set rCriteria = Range("B2:I71")Set rData = Range("V2:JX71")

not using as a free IT department. Thank s any ways.

SamT
08-27-2016, 12:33 PM
You're very welcome.

I am glad that you figured it out by yourself, that is the best way to learn.

When you can't get something to work, Come on back and we will get you there.

estatefinds
08-27-2016, 05:17 PM
Ok thank you