Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Hyperlink result as working hyperlink | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |