Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change a pasted web link to hyperlink
I have designed a worksheet wherein the cells contains the following
information The webpage address link A summary of the page to which the link points Now i wish to hyperlink the webpage adresses which are currently not in hyperlink blue probably becuase i cut - pasted them from the webpage How can i do this in bulk or is there some free available addin that does this as i have in excess of 500 links stored this manner Remember i wish to colour only the link not the cell which has other info too |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change a pasted web link to hyperlink
Try this macro after selecting all 500+ cells.
Sub MakeHyperlinks() 'David McRitchie Dim cell As Range For Each cell In Intersect(Selection, _ Selection.SpecialCells(xlConstants, xlTextValues)) With Worksheets(1) .Hyperlinks.Add anchor:=cell, _ Address:=cell.Value, _ ScreenTip:=cell.Value, _ TextToDisplay:=cell.Value End With Next cell End Sub Gord Dibben MS Excel MVP On Sat, 29 Mar 2008 13:10:51 -0700 (PDT), perfection wrote: I have designed a worksheet wherein the cells contains the following information The webpage address link A summary of the page to which the link points Now i wish to hyperlink the webpage adresses which are currently not in hyperlink blue probably becuase i cut - pasted them from the webpage How can i do this in bulk or is there some free available addin that does this as i have in excess of 500 links stored this manner Remember i wish to colour only the link not the cell which has other info too |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing a pasted link row into a column | Excel Discussion (Misc queries) | |||
Unprotect Hyperlink (pasted Link has blocked:: in it) | Excel Discussion (Misc queries) | |||
Excel- Hyperlink or link | Excel Discussion (Misc queries) | |||
right function on pasted link | Excel Worksheet Functions | |||
possible to link a hyperlink? | Excel Discussion (Misc queries) |