Hi
This code will only work for 1 Cell, I have tried different ways, but not sure if and how to do so. What I would like is for this Macro to Hyperlink all data in a Column. Could be anything up to about 70 rows, there are a number of Workbooks I require this to be done for. I created a button and scrolled down manually, but this is getting tedious.

Thank you


Sub UpdateHyperLink()
'
' UpdateHyperLink Macro
' Macro recorded 10/01/2013 by r872030
'

'
Range("A2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Sheets("SheetNames").Select
End Sub