i found this very helpful hope this helps. this is for Excel 2007
u need to first select the hyperlink cells and then press "Alt+F11"
u'll get a new window to setup Macro
just choose the sheet the hyperklink cells u have selected and then paste this
Dim h As Hyperlink
For Each h In Selection.Hyperlinks
h.Range.Offset(0, 1).Value = h.Address
then go back to the excel sheet where u have selected the hyperlinked cell u want to extract and press "Alt+F8" and click Run.
hope this works