Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I modify a Hyperlink with a function?
I have a column of several thousand cells that have different hyperlinks in each one. I would like to set up a column adjacent to this column and have the hyperlink address in this new column. I have found that there is not a paste special function that will do this and the excel "CELL" function does not work either - although it should. Any suggestions? a VBA solution would be just fine as well. -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=375695 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
hyperlink function | Excel Worksheet Functions |