Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-13-2022, 09:55 PM
gmayor's Avatar
gmayor gmayor is offline A macro to find interjections from a list and italicize them Windows 10 A macro to find interjections from a list and italicize them Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

That would be the principle. However you could use wildcards with minimal iterations in a macro using wildcards Replace using wildcards e.g.
Code:
Sub Macro1()
Const sFind As String = "<ah[\!\?\,.]{1,}|<AH[\!\?\,.]{1,}|<Ah[\!\?\,.]{1,}"
Const sRepl As String = "^&"
Dim oRng As Range
Dim vFind As Variant
Dim i As Integer
    vFind = Split(sFind, "|")
    For i = 0 To UBound(vFind)
        Set oRng = ActiveDocument.Range
        With oRng.Find
            Do While .Execute(findText:=vFind(i), _
                              MatchWildcards:=True, _
                              ReplaceWith:=sRepl)
                oRng.Font.Italic = True
                oRng.Collapse 0
            Loop
        End With
    Next i
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
A macro to find interjections from a list and italicize them Macro to Find & Highlight Words from List DRD992 Word VBA 15 06-17-2023 05:06 AM
A macro to find interjections from a list and italicize them Use VBA to find all cells with the same value and add to list trevorc Excel Programming 2 11-24-2021 06:51 PM
Find - Replace Macro using a table list mdw Word 0 08-01-2013 04:36 PM
A macro to find interjections from a list and italicize them Macro that can find phrase and then find another and copy jperez84 Word VBA 10 09-19-2012 04:48 PM
A macro to find interjections from a list and italicize them How to write a macro to find a specified name in a list of data? Jaffa Excel 1 10-23-2010 02:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 AM.


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