Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change hyperlink name to url
In excel I have a long list of hyperlinks to favorite places on the web. I
want to print the url addresses. When I turn off the hyperlink only the "friendly name" is left. Is there a way to change the friendly name to the url address without manually typing or right clicking/edit hyperlink and then copying the url for each one? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change hyperlink name to url
Here's one I did recently for a client.
Sub geturlinfo() lr = Sheets("copyweb").Cells(Rows.Count, "c").End(xlUp).Row For Each H In Sheets("copyweb").Range("c1:c" & lr) With Sheets("dest") If H.Hyperlinks.Count 0 Then myh = H.Hyperlinks(1).Address dlr = .Cells(Rows.Count, "a").End(xlUp).Row + 1 ..Cells(dlr, "a") = Mid(myh, 27, Len(myh) - 37) End If End With Next H End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "ttc" wrote in message ... In excel I have a long list of hyperlinks to favorite places on the web. I want to print the url addresses. When I turn off the hyperlink only the "friendly name" is left. Is there a way to change the friendly name to the url address without manually typing or right clicking/edit hyperlink and then copying the url for each one? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change application to run on a hyperlink | Links and Linking in Excel | |||
My hyperlink address change? | New Users to Excel | |||
How do I change the appearance of a hyperlink? | Excel Worksheet Functions | |||
hyperlink change when i alphabetize | Excel Discussion (Misc queries) | |||
macro to change a name of a hyperlink | Excel Discussion (Misc queries) |