Hi all,
I'm currently using this routine to delete doubles. Could someone out there tell me HOW to speed up things?? This get really slow if I have more than 2000 items.
The idea is: I've got 1 list (defined by variables list(x), where x can easily go up to 30,000), I'm just purging it of the doubles that are included.
Thanks in advance for your help,Code:ttt = 0 baseroutine: ttt = ttt + 1 If ttt > TotalNumberItemsList Then GoTo finish End If tttt = ttt flexroutine: tttt = tttt + 1 If tttt > TotalNumberItemsList Then GoTo baseroutine ElseIf UCase(list(ttt)) = UCase(list(tttt)) Then lista(tttt) = "" GoTo flexroutine End If GoTo flexroutine finish:
Cheers,
W.





Reply With Quote