batch hyperlink
 

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

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