Q:

Sorting URLS before I check for duplicates in VBA

I'm trying to run a few filters using VBA, where I then have the data output to an "analysis" sheet.
Everything works as it should so far - but I'm now trying to eliminate URL duplicates.
If unique_1 <> Sheets(1).Cells(x, 11) Then
The code snippet above will eliminate the duplicates, but only if I have already sorted by URLS (which is not something I can do with the data upfront)
I'm hoping I can sort using VBA, but haven't been able to so far and my eyes are killing me. Any help would be appreciated!
Thanks in advance for your help!
If Sheets(1).Cells(x, 12) = "X URL" Then
        If Sheets(1).Cells(x, 9) > 4 And Sheets(1).Cells(x, 9) < 10 Then               
            '//NEED TO SORT URLS HERE FIRST - BEFORE I CAN FIND DUPES//                
            If unique_1 <> Sheets(1).Cells(x, 11) Then
                O_2 = O_2 + 1
            End If
               unique_1 = Sheets(1).Cells(x, 11)
        End If
End If

A:

Use Range.Sort on whatever range you are trying to sort
As a side note, nothing in the code you listed seems to remove duplicates. At most, it counts how many there are.

