Hi guys.
Would you please help me with one Macro ? Below is Macro which works very good for DELETION of duplicit
rows. But I would like to do 2 things :
Please Login or Register to view this content.
1. Is possible somehow to change this macro, so that duplicit rows are NOT deleted but rather HIGHLIGHTED
with some color ? I could saw some macros somewhere, but there are tooo long. Below is short and readable
so I hoped that it can be done shortly also for HIGHLIGHTING option.
2. In this part of code >>
I understand that definition of my area is not so smart. Do you know why this is not working >>Please Login or Register to view this content.
Range (BBB & 99999) ? Variable I got using Mid function >>
Thanks a lot for any help.Please Login or Register to view this content.
------------------------------------------------------
Bookmarks