Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding text path via macro to activate hyperlink
I have an x amount of cells on column c that have numbers
which represent a html document, Is there any way to autmatically create a hyperlink via a macro to these cells? if not is there a macro that can add the following path to a range of cells with out deleting the the numbers that already occupy those cells? for example http://msf/respond1.asp?MSF=8861 http://msf/respond1.asp? represents the path that is not currently in the cell. and 8861 is in the cell without the path I want to add the path via a macro to a range of cells so that both the path and the number will create a hyperlink. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a Macro to a Hyperlink | Excel Discussion (Misc queries) | |||
How do I create a macro to remove path from hyperlink "address"? | Excel Discussion (Misc queries) | |||
Hyperlink in cells....how to activate it with out a mouse | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I de-activate hyperlink in Excel ? | New Users to Excel |