Thread: Find the row for a Hyperlink
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Find the row for a Hyperlink
On Fri, 16 Dec 2011 17:17:42 -0800 (PST), cubbybear3 wrote:

Thanks Ron,

Is there any way to identify the Hyperlink using the 1st method
(For Each rangeX In Sheets("x").Range("A1:G7")?

-pb


For Each rangeX in ...
If rangeX.Hyperlinks.Count 0 Then
Debug.Print rangeX.Address, rangeX.Hyperlinks(1).Address
End If
next rangeX
Reply With QuoteReply With Quote