Microsoft Office Forums - View Single Post - [Solved] How to find Word links (fields) to blank Excel cells?

macropod · 12-31-2016, 08:46 PM

You could use a macro like the following to delete all LINK fields whose result is effectively nothing:

Code:

Sub Demo()
Application.ScreenUpdating = False
Dim i As Long
With ActiveDocument
  For i = Fields.Count To 1 Step -1
    With .Fields(i)
      If .Type = wdFieldLink Then
        If Trim(.Result) = "" Then .Delete
      End If
    End With
  Next
End With
Application.ScreenUpdating = True
End Sub

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
For Mac macro installation & usage instructions, see: http://word.mvps.org/Mac/InstallMacro.html