Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-11-2023, 03:48 AM
Mai_ibs Mai_ibs is offline Macro stops working after the first paragraph Windows 10 Macro stops working after the first paragraph Office 2019
Novice
Macro stops working after the first paragraph
 
Join Date: Jul 2023
Posts: 2
Mai_ibs is on a distinguished road
Default Macro stops working after the first paragraph

Hello,

I need to create a macro to duplicate each of the paragraphs in a file (including the content within tables), maintaining the same formatting, and then hide the first paragraph in each instance (including the content within tables).

I checked this forum and I found a macro: it duplicates, keeps formatting and hide the content; however it stops working after the first paragraph. I don't know why.

This is the macro:

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
Next i
lbl_Exit:
Set oRng = Nothing
Set oPara = Nothing
Set oNewPara = Nothing
Exit Sub
End Sub


Thanks!
Reply With Quote
 

Tags
duplicate sentences, hide, paragraph formatting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro stops working after the first paragraph Drag and Drop Stops Working TucsonJack Word 7 04-26-2023 04:36 PM
Macro stops working after the first paragraph when using find in vba several times it stops working Salah Word VBA 1 03-02-2017 03:02 AM
OneNote Clipper Addon stops working dannyetlv OneNote 0 08-05-2016 09:12 AM
Autotransition stops while working on extended desktop IT1 PowerPoint 1 11-04-2015 11:19 PM
Outlook Stops Working TOKonline Outlook 0 09-26-2014 05:39 AM

Other Forums: Access Forums

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