hyperlink

[ericlch16]

I have columnA

1
2
3
4
5


1,3,4 has hyperlink... is there any way i can determine through excel which one has hyperlink of not? I have about 1000 rows... so i want to filter the one that has hyperlink and those that dont?

is that possible to isolate the ones that have and the ones that do not have?

thanks

 

[cb12]

You could try modifying this to suit your needs

Sub test()
Dim i As Integer

On Error Resume Next

    For i = 1 To 10
    
        If Cells(i, 1).Hyperlinks(1) Is Nothing Then
        Else: Cells(i, 1).Interior.Color = 3
        End If
        
    Next i

End Sub