Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a an excel file that contains one worksheet.
The worksheet contains more than 1500 rows of hyperlinks. I need to get the actual value of each cell that contains a hyperlink on the worksheet. For example, The display value for cell A2 is "Link to document". The actual value for the cell A2 is "A2=hyperlink("document1.doc","Link to document")". I need to parse through the cell values extracting the values that is within the hyperlink parentheses. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mixed cell displays--values and formulas showing on same worksheet | Excel Discussion (Misc queries) | |||
Calculate a date based on values in other cell, worksheet | Excel Worksheet Functions | |||
Build a reference to another worksheet from cell values in currentsheet | Excel Worksheet Functions | |||
excel 97: copy and paste values from one worksheet to another worksheet | Excel Programming | |||
excel 97: copy and paste values from one worksheet to another worksheet | Excel Programming |