I have an Excel file with urls in consequetive cells in a column. I want to
place the url information contained in the hyperlink in the cell next to the
hyperlink (the url is the info. that can be seen as you hover the mouse over
the hyperlink). The hyperlinks are dynamic and change regularly (almost
daily). Therefore the url information changes daily.

Things i have tried:
1. Use the edit hyperlink feature - copy the hyperlink and paste it in the
adjacent cell.
2. Use macro to automate the above action

The problem is:

The "copying of hyperlink" in step 1 is recorded as hard copy in the macro.
Hence, each time I run the macro, it just pastes the hard coded url in the
cell. It does not go to the source cell, copies the url in the cell and then
paste it. As I mentioned above, the hyperlink and therefore the urls in them
change frequently (almost daily). Therefore I need the copy function to copy
the url in the hyperlink at that time.

Your assistance is highly appreciated.

Thanks,

DM