Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to extract the URL part of a hyperlink in another cell?
Is there a function to extract the URL part of a hyperlink in another cell?
All I can see is the displayed text for the link. if I use, for example, =A1 in another cell, all I get is a copy of the displayed text. What I am trying to do is automatically create a column of proper urls, given a list behind "displayed" urls. Rufus |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to extract the URL part of a hyperlink in anot
Try this tiny UDF:
Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function -- Gary's Student "Rufus V. Smith" wrote: Is there a function to extract the URL part of a hyperlink in another cell? All I can see is the displayed text for the link. if I use, for example, =A1 in another cell, all I get is a copy of the displayed text. What I am trying to do is automatically create a column of proper urls, given a list behind "displayed" urls. Rufus |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to extract the URL part of a hyperlink in anot
Fabulous, works perfectly!
Thanks! Rufus "Gary''s Student" wrote in message ... Try this tiny UDF: Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function -- Gary's Student "Rufus V. Smith" wrote: Is there a function to extract the URL part of a hyperlink in another cell? All I can see is the displayed text for the link. if I use, for example, =A1 in another cell, all I get is a copy of the displayed text. What I am trying to do is automatically create a column of proper urls, given a list behind "displayed" urls. Rufus |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to extract the URL part of a hyperlink in
I have hyperlinks in Excel that link to a cell in another file. Your
function works, but it only gives me the name of the other file. How do I get the cell name that the hyperlink goes to? How do I get the worksheet that the hyperlink goes to? Thanks for your help. "Gary''s Student" wrote: Try this tiny UDF: Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function -- Gary's Student "Rufus V. Smith" wrote: Is there a function to extract the URL part of a hyperlink in another cell? All I can see is the displayed text for the link. if I use, for example, =A1 in another cell, all I get is a copy of the displayed text. What I am trying to do is automatically create a column of proper urls, given a list behind "displayed" urls. Rufus |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to extract the URL part of a hyperlink in
I answered my own question... I looked in the object browser under hyperlin,
and found the .address that you used. Also noticed that there is a .subaddress . I tried this and got both the worksheet and the cell (i.e. worksheet!cell). I guess I don't have this question any longer. Thanks. Jim "Jim" wrote: I have hyperlinks in Excel that link to a cell in another file. Your function works, but it only gives me the name of the other file. How do I get the cell name that the hyperlink goes to? How do I get the worksheet that the hyperlink goes to? Thanks for your help. "Gary''s Student" wrote: Try this tiny UDF: Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function -- Gary's Student "Rufus V. Smith" wrote: Is there a function to extract the URL part of a hyperlink in another cell? All I can see is the displayed text for the link. if I use, for example, =A1 in another cell, all I get is a copy of the displayed text. What I am trying to do is automatically create a column of proper urls, given a list behind "displayed" urls. Rufus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading Cell Function??? | Excel Worksheet Functions | |||
Hyperlink problem to cell in same workbook | Excel Discussion (Misc queries) | |||
ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) |