Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a hyperlink as the text in the cell?
If I have cells A1-A5 as these IP addresses:
http://12.23.34.11 http://12.23.34.12 http://12.23.34.13 http://12.23.34.14 http://12.23.34.15 and they are not hyperlinks yet, is there a way to get Excel to insert a hyperlink where the hyperlink will automatically point to the contents of the cell itself ie. the hyperlink in cell A1 should "http://12.23.34.11" and so on? I know you can do this manually, but the automatic option would save a LOT of time. Thanks, Alain |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a hyperlink as the text in the cell?
In B1 enter:
=HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu201001 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a hyperlink as the text in the cell?
For the same(!) range of cells [no helper-Column]:
Use the following VBA Code after the range of cells have been selected: ----------------------- Sub Make_HyperLink() For Each CL In Selection If cl.Text Like "*www*" Then ActiveSheet.Hyperlinks.Add Anchor:=cl, Address:= cl.Text, TextToDisplay:=cl.Text End If If cl.Text Like "*@*.*" Then ActiveSheet.Hyperlinks.Add Anchor:=cl, Address:= "mailto:" & cl.Text, TextToDisplay:=cl.Text End If Next End Sub ----------------------- Micky "Alain Dekker" wrote: If I have cells A1-A5 as these IP addresses: http://12.23.34.11 http://12.23.34.12 http://12.23.34.13 http://12.23.34.14 http://12.23.34.15 and they are not hyperlinks yet, is there a way to get Excel to insert a hyperlink where the hyperlink will automatically point to the contents of the cell itself ie. the hyperlink in cell A1 should "http://12.23.34.11" and so on? I know you can do this manually, but the automatic option would save a LOT of time. Thanks, Alain . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a hyperlink in text in a paragraph | Excel Discussion (Misc queries) | |||
how do I insert a cell value in a hyperlink formula | New Users to Excel | |||
HYPERLINK - insert within a text sentence | Excel Worksheet Functions | |||
How do I insert the value of a cell into a Hyperlink | Excel Discussion (Misc queries) | |||
Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) |