Hyperlink based on cell content

[Chino]

Hi Guys,

I'm sure this is a really simple question (apologies in advance if it is) but I'm very new to VBA so am hoping I can get some help!

I have a spreadsheet containing a row of filenames which I need to convert into hyperlinks to the files which are stored on a sharepoint site. I originally added the links by hand but for some reason they break everytime I reopen the spreadsheet so I want to automate creating the hyperlinks so I don't have to add them by hand everytime!

To clarify I want the code to go through the list and change the text "Filename.xls" into a hyperlink to "sharepointsite\Filename.xls" and then move on to "Filename2.xls" and so on.

Can anyone help me with this?

Thanks

 

[Juan Pablo González]

You could just use the HYPERLINK function, no VBA required.

 

[Chino]

Aah! I didn't know that existed, thanks that works a treat and thanks for the quick reply!