Looking for Help to Select Cells Containing Hyperlink Text Only

Question

I am trying to filter cells or select cells that only contain hyperlink text. Is there an easy formula or filter feature I can use for this? Potentially a regex filter example?

Thank you in advance!

hansvogelaar · Answer

ali3chat&nbsp;
You might use this macro:
Sub SelectHyperlinks()
    Dim wsh As Worksheet
    Dim hyp As Hyperlink
    Dim rng As Range
    Set wsh = ActiveSheet ' or specify the sheet
    For Each hyp In wsh.Hyperlinks
        If rng Is Nothing Then
            Set rng = hyp.Range
        Else
            Set rng = Union(rng, hyp.Range)
        End If
    Next hyp
    If rng Is Nothing Then
        MsgBox "No Hyperlinks", vbInformation
    Else
        rng.Select
    End If
End Sub

Forum Discussion

Looking for Help to Select Cells Containing Hyperlink Text Only

1 Reply