Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink Help
Hi All
If I paste a hyperlink off a web page into a cell in a workbook, then move the mouse over it a litte box pops up with text or numbers in it. How can I get this text Etc, into the cell to the left of the pasted cell. Thanks in Advance. Dave |
#2
|
|||
|
|||
Saved from a previous post:
One way to extract those URL's from a hyperlink created via Insert|Hyperlink is with a userdefinedfunction. Here's one that may help: Option Explicit Function GetURL(Rng As Range) As String Application.Volatile Set Rng = Rng(1) If Rng.Hyperlinks.Count = 0 Then GetURL = "" Else GetURL = Rng.Hyperlinks(1).Address End If End Function So if you had a hyperlink in A1, you could put =getURL(a1) in that adjacent cell. Be aware that if you change the hyperlink, then this formula cell won't change until your workbook calculates. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dave wrote: Hi All If I paste a hyperlink off a web page into a cell in a workbook, then move the mouse over it a litte box pops up with text or numbers in it. How can I get this text Etc, into the cell to the left of the pasted cell. Thanks in Advance. Dave -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Hyperlink Length | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
How can I extract hyperlink value | Excel Discussion (Misc queries) |