Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 11-30-2024, 07:42 AM
gmaxey gmaxey is offline VBA Insert tab before array of words Windows 10 VBA Insert tab before array of words Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,636
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Vivka,


Thanks. I didn't have time yesterday to delve into a FR solution. Here is one that seems to work. I'm not confident it is any better than the solution posted yesterday:

Code:
Sub InsertTab_Before_FirstInstance()
Dim oPar As Paragraph
Dim oRng As Word.Range, oFIRng As Range
Dim arrWords
Dim i As Long, j As Long
  arrWords = Array("means", "includes", "has", "any")
  For Each oPar In ActiveDocument.Range.Paragraphs
    Set oFIRng = Nothing
    Set oRng = oPar.Range
    j = 0
    Do
      For i = j To UBound(arrWords)
        oRng.Start = oPar.Range.Start
        With oRng.Find
          .ClearFormatting
          .Replacement.ClearFormatting
          .Text = arrWords(i)
          .MatchWholeWord = True
          If .Execute Then
            'We have found a first instance word.  But, does another FI word precede it?
            Set oFIRng = oRng.Duplicate
          End If
          'Index and look for next word in the array
          j = j + 1
          If j = UBound(arrWords) + 1 Then Exit Do
        End With
      Next i
      If oFIRng Is Nothing Then Exit Do
    Loop
    If Not oFIRng Is Nothing Then
      If oFIRng.Characters.First.Previous = " " Then oFIRng.Characters.First.Previous.Delete
      If Not oFIRng.Characters.First.Previous = Chr(9) Then oFIRng.InsertBefore Chr(9)
    End If
  Next
lbl_Exit:
  Exit Sub
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Insert tab before array of words VBA help non breaking spaces for array of words not working correctly Shelley Lou Word VBA 2 03-08-2023 03:15 AM
VBA Insert tab before array of words Macro to insert certain words if the number of words than 20 laith93 Word VBA 6 10-28-2022 01:12 AM
VBA Insert tab before array of words Insert words before and after any italics benfarley Word VBA 1 03-30-2022 08:35 PM
An array of words from a document knowing the font style Kreol2013 Word VBA 0 07-08-2013 01:29 AM
VBA Insert tab before array of words Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft