Check to see if SubAddress of a hyperlink is already on worksheet

[Pookiemeister]

How can I check if a particular SubAddress of a hyperlink is already on a worksheet? Thank you

 

[etaf]

can you give and example of hat you are after
probably a search()
depends on what you want to show if found if not found

 

[Micron]

maybe

Dim hLink As Hyperlink
For Each hLink In Me.Hyperlinks
   If hLink.SubAddress = "certain link" Then
        debug.print hLink.SubAddress
    End If
Next