| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro add Hyperlink formula
A formula that finally works (thanks Dave Ritchie) is
=HYPERLINK("#"&CELL("address",Datasheet!C15),Datas heet!C15). I can copy and it to other cells and also don't get cannot open specified file error But how do I automate the creation of the the macro from original cell contents of =Datasheet!c15 or =+Datasheet!C15 to above hyperlink formula Thanks very much. Charles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro in Hyperlink | Excel Discussion (Misc queries) | |||
| Hyperlink to a Macro | Excel Discussion (Misc queries) | |||
| Hyperlink Macro | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
Threaded Mode
