Microsoft Office Forums - View Single Post - [Solved] Macro to color row of Word table based on found text

macropod · 11-14-2015, 10:01 PM

Try:

Code:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "\{[MTWFS][ondayueshrit]{2,7} Workshop\}"
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchWildcards = True
    .Execute
  End With
  Do While .Find.Found
    If .Information(wdWithInTable) = True Then
      .Rows(1).Shading.BackgroundPatternColorIndex = wdYellow
      '.Delete
    End If
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Application.ScreenUpdating = True
End Sub

If, as your post suggests, you want to delete the found text, simply un-comment '.Delete'.