• 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
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

vletm

Excel Ninja
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?
 

S P P

Member
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.
 
Top