Microsoft Office Forums - View Single Post - [Solved] ActiveDocument.Words(i).Characters.Last.Text statment not working

macropod · 12-02-2015, 03:10 PM

The problem you're having is mainly due to each 'word' including the trailing space, if any. Even so, there's a simpler way:

Code:

Sub Demo()
Application.ScreenUpdating = False
Dim StrOut As String
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "<[!^13 ]@[aeiouy] [aeiouy][! ]@>"
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchWildcards = True
    .Execute
  End With
  Do While .Find.Found
    StrOut = StrOut & vbCr & .Text
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
ActiveDocument.Range.InsertAfter vbCr & Chr(12) & "Hiatus List" & StrOut
Application.ScreenUpdating = True
End Sub