Hi,
Can anyone help me with some VBA to highlight duplicates within a column. If a cell has a duplicate then I would like it and all its brothers to be highlighted. I have achieved this using a for.. next loop but as I have thousands of records it is inelegant (and slow) I would like to use the FIND method.
Many thanks
Can anyone help me with some VBA to highlight duplicates within a column. If a cell has a duplicate then I would like it and all its brothers to be highlighted. I have achieved this using a for.. next loop but as I have thousands of records it is inelegant (and slow) I would like to use the FIND method.
Many thanks