Hyperlink

[Snakebyte]

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

 

[Ron de Bruin]

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/buildtoc.htm#MakeHyperLinks