Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
URL function
Folks:
In column #1 of my spreadsheet, I have a list of hyperlinks. When I hold my mouse over these links, the URL (or email address) associated with these links would show up. * Is there an Excel function (or keyboard combination) that I can use to copy the URL (or email address) associated with my links to column #2 ? Thanks, JoJo |
#2
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
URL function
Try this User Defined Function:
Function hyp(r As Range) As String hyp = "" If r.Hyperlinks.Count 0 Then hyp = r.Hyperlinks(1).Address Exit Function End If If r.HasFormula Then rf = r.Formula dq = Chr(34) If InStr(rf, dq) = 0 Then Else hyp = Split(r.Formula, dq)(1) End If End If End Function Should work for both Inserted hyperlinks and hyperlinks entered with the =HYPERLINK() function. -- Gary''s Student - gsnu200858 "JoJo" wrote: Folks: In column #1 of my spreadsheet, I have a list of hyperlinks. When I hold my mouse over these links, the URL (or email address) associated with these links would show up. * Is there an Excel function (or keyboard combination) that I can use to copy the URL (or email address) associated with my links to column #2 ? Thanks, JoJo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |