Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-20-2021, 04:40 AM
effimera effimera is offline How to duplicate paragraphs & format them Windows 10 How to duplicate paragraphs & format them Office 2019
Novice
How to duplicate paragraphs & format them
 
Join Date: Jun 2021
Posts: 8
effimera is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Without the document to test, the following should work

Code:
Sub Macro1()
Dim oRng As Range
Dim oPara As Range, oNewPara As Range
Dim i As Long
    Set oRng = Selection.Range
    If oRng.End = ActiveDocument.Range.End Then
        oRng.InsertParagraphAfter
    End If
    For i = oRng.Paragraphs.Count To 1 Step -1
        Set oPara = oRng.Paragraphs(i).Range
        Set oNewPara = oPara.Duplicate
        oNewPara.Collapse 0
        oNewPara.FormattedText = oPara.FormattedText
        oNewPara.Font.Italic = True
    Next i
lbl_Exit:
    Set oRng = Nothing
    Set oPara = Nothing
    Set oNewPara = Nothing
    Exit Sub
End Sub

Thank you, gmayor!
It works perfectly - much obliged
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to duplicate paragraphs & format them Duplicate paragraphs except in tables jalve Word VBA 21 05-26-2021 07:38 PM
How to duplicate paragraphs & format them Format multiple paragraphs differently Dave T Word VBA 7 07-31-2019 08:12 PM
How to duplicate paragraphs & format them delete 1 or 2 adjacent duplicate paragraphs, macro moorea21 Word 4 11-01-2018 12:53 PM
How to duplicate paragraphs & format them How to find duplicate phrases/paragraphs in a long document iamgator Word VBA 5 12-27-2016 01:34 AM
How to duplicate paragraphs & format them VBA to set format for paragraphs that meet with specific requirements AustinBrister Word VBA 3 06-01-2015 07:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 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