Thread: batch hyperlink
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default batch hyperlink

Masoud,
Is this what you mean ?

Dim HLink As Hyperlink

For Each HLink In Worksheets(1).Hyperlinks
Debug.Print HLink.Address
Next

NickHK

"Masoud" wrote in message
...
hello.

in my file (Excel) there are several items (records) that are linked to
external

source files,I like to find one list that tell me each record is linked to
which external

file name.

Thanks in advanced