Hello VBA's friends, I'll put here a code that does its job well, in fact it highlights duplicates, however this code only works on one vertical range (1 column) but I would like to highlight all duplicates on all ranges (column A and B)
Thank you
EDIT i would like to keep this For Each loop that I'm more familiar
Please Login or Register to view this content.
Last edited by XLalbania; 05-30-2021 at 08:37 AM.
I see this in your code
this never see to column BPlease Login or Register to view this content.
cheers
Leo
Hi Leo,
Thanks for the answer i tried with Range("A1:B8") but does not work, there is an error run time 1004 on this line of code
Please Login or Register to view this content.
You can't match that way.
Dictionary instead.
Please Login or Register to view this content.
How aboutPlease Login or Register to view this content.
Hello friends
Thank so much @Fluff213 and @Jindon both codes work fine
But since I'm learning VBA, what is? this is new for me.... VBA never EndPlease Login or Register to view this content.
I add reputation to @jindon only because as been faster
Thank you so much
That the part is setting the reference to Dictionary object.
https://docs.microsoft.com/en-us/off...tionary-object
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks