Good morning!

I have taken some time out of my busy schedule of organising world peace to work on a spreadsheet on which the hyperlinks do not work.

When a web table was pasted onto Excel, the links were pasted too, but they were missing the first part of the address. e.g.

http://www.vbaexpress.com/forum/newt...newthread&f=17
would be pasted as:
forum/newthread.php?do=newthread&f=17

So how can I write a macro that would put (in this example) "http://www.vbaexpress.com/" in front of all the current links in my selection to make them complete again?

Some cells are empty, and not all cells are hyperlinks, by the way.

Thanks a million.