Forum Discussion
Daniel_Boro
Oct 26, 2020Copper Contributor
broken links
Hi, I broke all the links in the edit links tab, but they are still showing - see attached file Could this slow down the file? How can it be fixed? Thank you! Updating Media ...
NikolinoDE
Oct 26, 2020Platinum Contributor
Here is a macro to quickly clear all ghost links.
Sub Test()
Dim WS As Worksheet
Dim F As Object 'FormatCondition
For Each WS In Worksheets
For Each F In WS.UsedRange.FormatConditions
If F.Type = xlExpression Then
If InStr(1, F.Formula1, "#REF!", vbTextCompare) > 0 Then
F.Parent.FormatConditions.Delete
End If
End If
Next
Next
End Sub
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here