Creating multiple hyperlinks

Does anybody know how to create multiple hyperlinks?

I have a large excel file that has www.website1.com etc but does not have a hyperlink on it so I cannot access this via the spreadshhet. I have hundreds of these that I want to crate a hyperlink for. Any tips?

The below code will transform all cell entries in column A from row 1 to r to Hyperlinks.
You can adapt the code to cover any range you like.

Dim i As Integer
Dim path As String
For i = 1 To r "r is the end of your range"
path = Range("A" & i).Value
Range("A" & i).Hyperlinks.Add Range("A" & i), path
Next i

Is this any help
Pete G