versuche es mal mit dem folgenden Code (vorher eine Sicherheitskopie der Arbeitsmappe anlegen!):
Sub hyperlink_inhalte_ersetzen2()
Dim loZeile As Long
Dim hyAdresse As Hyperlink
Dim strAnzeige As String
With Worksheets("Tabelle1")
For loZeile = 1 To 1000
If .Cells(loZeile, 2).Hyperlinks.Count Then
strAnzeige = .Cells(loZeile, 2).Value
.Cells(loZeile, 2).Hyperlinks(1).TextToDisplay = .Cells(loZeile, 2).Hyperlinks(1).Address
.Cells(loZeile, 2).Hyperlinks(1).Delete
.Cells(loZeile, 2).Value = Replace(.Cells(loZeile, 2).Value, "\a\", "\a1\")
ActiveSheet.Hyperlinks.Add Anchor:=.Cells(loZeile, 2), Address:=Cells(loZeile, 2).Value, TextToDisplay:=strAnzeige
End If
If .Cells(loZeile, 7).Hyperlinks.Count Then
strAnzeige = .Cells(loZeile, 7).Value
.Cells(loZeile, 7).Hyperlinks(1).TextToDisplay = .Cells(loZeile, 7).Hyperlinks(1).Address
.Cells(loZeile, 7).Hyperlinks(1).Delete
.Cells(loZeile, 7).Value = Replace(.Cells(loZeile, 7).Value, "\a\", "\a1\")
ActiveSheet.Hyperlinks.Add Anchor:=.Cells(loZeile, 7), Address:=Cells(loZeile, 7).Value, TextToDisplay:=strAnzeige
End If
If .Cells(loZeile, 8).Hyperlinks.Count Then
strAnzeige = .Cells(loZeile, 8).Value
.Cells(loZeile, 8).Hyperlinks(1).TextToDisplay = .Cells(loZeile, 8).Hyperlinks(1).Address
.Cells(loZeile, 8).Hyperlinks(1).Delete
.Cells(loZeile, 8).Value = Replace(.Cells(loZeile, 8).Value, "\a\", "\a1\")
ActiveSheet.Hyperlinks.Add Anchor:=.Cells(loZeile, 8), Address:=Cells(loZeile, 8).Value, TextToDisplay:=strAnzeige
End If
Next loZeile
End With
End Sub