Wildcard search fails in table

[NobodysPerfect]

Hi to all,

within a procedure I have a simple wildcard search "FirstItem*LastItem" to hightlight the passages between two given items.

It works fine: except in tables. Whenever the items are within a table Search & Replace simply ignores them.



So my question: does Word's wildcard seach really ignores text in tables? Or am I doing sth wrong.

Thanks for your answers.
NP

[gmaxey]

Your doing something wrong. Without seeing your code, "what" is anyone's guess.

[NobodysPerfect]

Ok, here it comes:

Sub HighlightRanges()
Dim doc As Document: Set doc = ActiveDocument
Dim SRange As Range: Set SRange = doc.Range
Dim RePaintText As Variant
Dim i As Long

    RePaintText = Array("Pos.", "Wert", "077.0087")
    
    Application.ScreenUpdating = False
    
    ClearFindnReplace
    Options.DefaultHighlightColorIndex = wdViolet
    With SRange.Find
        .Text = "Pos.*Wert"
        .Replacement.Highlight = True
        .MatchWildcards = True
        .Execute Replace:=wdReplaceAll
    End With

    ClearFindnReplace
    Options.DefaultHighlightColorIndex = wdYellow
    With SRange.Find
        .Replacement.Highlight = True
        For i = LBound(RePaintText) To UBound(RePaintText)
            .Text = RePaintText(i)
            .Execute Replace:=wdReplaceAll
        Next i
    End With

End Sub

Sub ClearFindnReplace()

    With Selection.Find
       .ClearFormatting
       .Replacement.ClearFormatting
       .Text = ""
       .Replacement.Text = ""
       .Forward = True
       .Wrap = wdFindStop
       .Format = False
       .MatchCase = False
       .MatchWholeWord = False
       .MatchWildcards = False
       .MatchSoundsLike = False
       .MatchAllWordForms = False
    End With
    
End Sub

Data between "Pos." and "Wert" shall be highlighted - with some exceptions within the highlighted area. So part one highlights the range from "Pos." to "Wert", part two 're-paints' given strings (incl. "Pos." and "Wert").

As I wrote, works fine, but ignores tables.

Thanks
NP

[gmaxey]

Let me revise my earlier statement. Your code works if the Pos. ????? Wert is in the same cell. However, if is spans multiple cells, then yes it appears that the wildcard "*" will not work.

Sorry for misleading you.

[NobodysPerfect]

Hi,

I never noticed that (bug?) before. Good to know. I will switch to a two-range-search, but that will be considerably slower .

Cheers
NP