| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieving hyperlink from cell
I have hyperlinks in a spreadsheet. However, I'd like for a cell to equal
it's hyperlink address. For example, in A1 I have CCNC 2005- Consumer Commmunications & Networking with the hyperlink address as http://www.comsoc.org/confs/index/html. I can't see this in the formula bar. I can only see it through the Edit Hyperlink menu option. I want D1 to equal http://www.comsoc.org/confs/index/html and have every cell in D to follow through. Any ideas? Many Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving first non-blank cell during a V-LOOKUP | Excel Discussion (Misc queries) | |||
| Retrieving Values from Cell with Macro | Setting up and Configuration of Excel | |||
| Retrieving a tuple for a cell. | Excel Discussion (Misc queries) | |||
| Retrieving a specific cell from multiple worksheets | Excel Worksheet Functions | |||
| Cell searching and retrieving | Excel Discussion (Misc queries) | |||
Linear Mode
