How to activate a column of URLs...

I've got an entire column of URLs in a spreadsheet and I don't know how to make them all active links without going into each cell and activating them one-by-one.  Is there a way of selecting the entire column and turning them on?

I can think of two easy approaches to this problem.

1. simply use the =HYPERLINK(reference,[friendly name]) formula to generate a column of hyperlinks adjacent to your column of URLs
2. use the following VBA code to make a hyperlink in each cell that contains a URL

Sub AddHyperlinks()
    Dim rngCe As Range
    On Error Resume Next
    For Each rngCe In Selection
        rngCe.Parent.Hyperlinks.Add anchor:=rngCe, Address:=rngCe.Value2
    Next rngCe
End Sub

Peter

Thanks for that input.

Since the values in that column are formulas themselves

[="http://www.blahblah.com/"&[@[ColumnA]]

...I just tossed [=HYPERLINK({formula})] in there at the front.  

Your input is appreciated.

- Art