• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Paint Duplicate Lines

S P P

Member
Good evening!

How to paint the B:Q line you are typing is similar to any of the above
 

Attachments

  • SPP How to Paint Duplicate Lines.xlsm
    16.4 KB · Views: 8
Does this help?
Type in Columns B2 to P29,when its a duplicate ,the duplicates wil highlight in Column Q
 

Attachments

  • SPP How to Paint Duplicate Lines-1.xlsm
    16.7 KB · Views: 5
S P P
This sample would work even all used values are eg 1, 11, 111 combinations.
 

Attachments

  • SPP How to Paint Duplicate Lines.xlsm
    24.3 KB · Views: 7
Belleke

Good Morning!

I need you to paint the cell so I can use another code to identify the cell as in the vletm example

vletm

Good Morning!

The vba you made works I need you to paint the cell to identify the duplicated cell with a vba I have.

See if you can change the VBA I entered.
 

Attachments

  • SPP How to Paint Duplicate Lines1vletm.xlsm
    24.2 KB · Views: 4
S P P
Did You ask something new again?
... means, why You didn't ask at once - what else would You like to get?

... What would You like to get to range T2:W2? ... all empty ... hmm?

... What would Your cell B1 red writing really mean?
 
When I press the button to check for duplicity, I have attached a command of a macro
that is in the module of this file that informs in V2 the address of the painted cell.

If you have a way to modify it to identify the 1st painted cell, I can also help you.

If you can modify it to identify the 1st cell painted also on T2. I provide you with

A U2 and W2 do not need to do anything.
 
Back
Top