Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Activating hyperlinks
In Excel 2010, I have a range of cells into which I have copied and
pasted URLs. They all pasted as text and I want them to be active hyperlinks. I can activate them one at a time by simply positioning the cursor at the end of the URL and pressing Enter but I want to activate them all at once. I tried: - Select the range of cells - Right click - Click Hyperlink - Select "Link to: Existing File or Web Page" - Select "Look In: Browse the Web" That simply opens my browser. How can I activate the whole range at once? Dick Evans |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Activating hyperlinks
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Activating hyperlinks
On Tue, 17 Jun 2014 20:59:46 +0200, Claus Busch
wrote: hi, Am Tue, 17 Jun 2014 14:40:54 -0400 schrieb : In Excel 2010, I have a range of cells into which I have copied and pasted URLs. They all pasted as text and I want them to be active hyperlinks. try (if your strings are not in column A then modify the code): Sorry, I'm not writing a macro, I'm just looking for a way to click my way to my goal. Sub ActivateHyperlinks() Dim rngC As Range Dim LRow As Long With ActiveSheet LRow = .Cells(Rows.Count, 1).End(xlUp).Row For Each rngC In .Range("A1:A" & LRow) .Hyperlinks.Add _ anchor:=rngC, _ Address:=IIf(Left(rngC.Text, 4) < "http", _ "http://" & rngC.Text, rngC.Text) Next End With End Sub Regards Claus B. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Activating hyperlinks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks? | Excel Programming | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
Need macros for activating multiple hyperlinks | Excel Programming | |||
Need macros for activating multiple hyperlinks | Excel Programming | |||
Activating/De-activating buttons | Excel Programming |