VBA Adding missing Punctuation to end of Paragraphs

Shelley Lou · #1 03-04-2024, 09:17 AM

Hi Andrew, that is an excellent idea of looking for the duplication instances after the code has run. The below looks for instances of ;]; or .]. and removes the duplicate punctuation after the square bracket to be ;] or .] - this works well but only if the square bracket is not within a text form field. I'm not sure what to add to the code to look for if the square bracket is within a text form field.

Code:

Sub RemovePuncDemo1()
Dim oRng As Range
Set oRng = ActiveDocument.Range
With oRng.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchWildcards = True
    .text = "([;.])([\]])([;.])"
    .Replacement.text = "\1\2"
    .Execute Replace:=wdReplaceAll
    End With
End Sub

Capture.JPG

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA help with punctuation code	Shelley Lou	Word VBA	0	12-09-2022 05:39 AM
Adding punctuation to body of text	Sweetpea7	Word	5	08-29-2021 07:44 PM
punctuation order	fariz	Word	2	10-31-2016 12:57 AM
Punctuation	lexsper	Word	0	04-06-2015 07:26 AM
Paragraph border missing on interior paragraphs	strathglass	Word	1	09-19-2011 02:41 PM