Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a function or property to extract the hyperlink from a cell
I copy a list of hyperlinks with friendly names into a spreadsheet.
However, I want to extract the underlying hyperlinks into their own cells. Is there a function or a property I can use in a macro to address the hyperlink behind the friendly name? Thx, J |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a function or property to extract the hyperlink from a cell
Please don't multipost.
-- David Biddulph "J" wrote in message ... I copy a list of hyperlinks with friendly names into a spreadsheet. However, I want to extract the underlying hyperlinks into their own cells. Is there a function or a property I can use in a macro to address the hyperlink behind the friendly name? Thx, J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a function or property to extract the hyperlink from a cell | Excel Discussion (Misc queries) | |||
How to extract a web address from a hyperlink cell? | Excel Discussion (Misc queries) | |||
VBA Code For OR-Function Using Cell Property | Excel Discussion (Misc queries) | |||
Is there a function to extract the URL part of a hyperlink in another cell? | Excel Worksheet Functions | |||
Extract hyperlink string from excel cell | Links and Linking in Excel |