Excel to World find Wholeword

[jazzyt2u]

Hi,

In 2007 I am copying words from Excel and finding them in Word. My problem is when there's data such as:
Strawberry Zinger
Strawberry

If I search for "Strawberry" in Word and Strawberry Zinger appears first in the Word Template it stops there even though I have .MatchWholeWord = True


'Ice Cream Names:
'Strawberry Zinger
'Strawberry Wave
'Strawberry
MyFlavor = Strawberry
With oWord.Selection.Find
.Forward = True
.MatchWholeWord = True
.Execute FindText:=MyFlavor
End With



Thank you,
Jazzyt2u

[Kenneth Hobs]

That makes sense to me. What did you expect?

If you did it manually, I suspect that the results would be the same.