Esta macro ajudará
Sub SwapIt()
For i = 2 To 579
If Range("A" & i).Value <> "" And Range("I" & i).Value <> "" Then
Dim newLink As String ' the new link string needs a place to live... just like me!
If Range("A" & i).Hyperlinks.Count = 1 Then
newLink = Range("A" & i).Hyperlinks(1).Address ' Get the old horrible link :)
Range("I" & i).Hyperlinks.Add anchor:=Range("I" & i), Address:=Range("I" & i) ' horrible hack, just to get it to a link
Range("I" & i).Hyperlinks(1).Address = newLink '' replace with the new link... Much better. Like a ray of sunshine
End If
End If
Next i
End Sub
Isso moverá o hiperlink De A2 para I2, depois A3 para I3, etc.