| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink copy paste
Hi everyone.
There is a text on a cell and hyperlink of a website linked to it. I would like to have a macro so that when I chose the cell and run the macro, it reads what the hyperlink is and replace the text in the cell with the actual web address that the hyperlink has. I can do the same by right clicking and chosing edit hyperlink, then copy the hyperlink and paste it. But there are hundreds of cells like this so I need a macro for it. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy / Paste Hyperlink, but not Formats | Excel Discussion (Misc queries) | |||
| Hyperlink Copy & Paste | Excel Discussion (Misc queries) | |||
| Copy picture and paste hyperlink | Excel Worksheet Functions | |||
| Copy/Paste Hyperlink Address | Excel Discussion (Misc queries) | |||
| hyperlink copy / paste | Excel Discussion (Misc queries) | |||
Threaded Mode
