Activating a cell make hyperlink active

[MattMax]

Hello,

I have a worksheet of web URLS, but they are not active links. If I click into a cell and out of it the link will become active. However, I'm not sure how to do this for the entire column. Any suggestions? Is this a loop with send keys?

Thanks,
MattMAx

 

[MattMax]

I figured it out...

Sub Macro2()
'
' Macro2 Macro
'
last_row = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

For x = 2 To last_row
Link = Cells(x, 4).Value
Cells(x, 4).Select
ActiveSheet.Hyperlinks.Add anchor:=Selection, Address:= _
Link, TextToDisplay:= _
Link
Next x
End Sub