#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
Is this for a language translation project?
I'm thinking you will need a method of showing/hiding either paragraph instance so there needs to be some way of identifying each series
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
There was nothing in your original code that hid content:
Code:
Sub Macro1() Dim oRng As Range Dim oPara As Range, oNewPara As Range Dim i As Long Set oRng = ActiveDocument.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 oPara.Font.Hidden = True Next i lbl_Exit: Set oRng = Nothing Set oPara = Nothing Set oNewPara = Nothing Exit Sub End Sub |
#4
|
|||
|
|||
Thanks Greg and Andrew!
Yes, this is for a translation project. Thanks for adding that line, Greg. I added it on my local but after several tests, I forgot to paste it here. Anyways, I'm still having issues Thanks again for checking! |
Tags |
duplicate sentences, hide, paragraph formatting |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drag and Drop Stops Working | TucsonJack | Word | 7 | 04-26-2023 04:36 PM |
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 |