with A1 active use this macro
Sub test()
With ActiveSheet
.Hyperlinks.Add Anchor:=ActiveCell, _
Address:=ActiveCell.Offset(1, 0).Hyperlinks(1).Address
End With
End Sub
See this webpage also
http://www.mvps.org/dmcritchie/excel...MakeHyperLinks
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Snakebyte " wrote in message ...
Hi
I have made a movie database i excel, but I'm having problems with
hyperlinks.
ex.
Cell:
A1 = Down By Law
B1= http://www.imdb.com/title/tt0090967/
I want excel to copy the link address B1 and make it
the hyperlink of the display name "Down By Law" (A1).
Can this be done without the use of another collumn
Thanks
---
Message posted from http://www.ExcelForum.com/