Find dupes, list in MsgBox with cell.address convert ws wide code to one sheet
Hi Garry,
Am Sun, 25 May 2014 18:50:40 -0400 schrieb GS:
I'm thinking that once the dictionary is loaded, you don't need to use
CountIf/Find since relooping the array for items already in the
dictionary can returns the item plus Cells(i, "T").Address. This would
be orders of magnitude faster if the list is lengthy with lots of
dupes!
can you please explain a little further. Howard wants to list the dupes
with the addresses. The dictionary gives me all items but I don't know
if these items occur only once or more in column T.
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|