Replacing paragraph formatting before column break also changes the next paragraph after the break

macropod · #1 09-21-2015, 09:39 PM

You would need to use a macro for that, as it appears the column break is attached to the paragraph following it. Such a macro might be coded as:

Code:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "^p^n"
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    .Execute
  End With
  Do While .Find.Found
    .Paragraphs.First.Style = "My Style"
    If .End = ActiveDocument.Range.End Then Exit Sub
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Application.ScreenUpdating = True
End Sub

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm.

jjmartin1340 · #2 09-21-2015, 10:42 PM

I've been thinking about this for about a year, and just now the answer came to me.
I don't use the @ character in my document.
So I Replaced: ^p^n with @^p^n.
Now the last paragraph in each column contains @.
Now I Replaced @ with @ with the desired formatting.
Then I verified the formatting.
Then I Replaced @ with nothing, thus removing it.
Now the last paragraph in each column is properly formatted, without affecting the next paragraph.

Why did it take me so long to think of such a simple method?
I fall back on my standard answer these days: "I'm 74 years old".

macropod · #3 09-21-2015, 10:50 PM

Quote:

Originally Posted by jjmartin1340

Why did it take me so long to think of such a simple method?
I fall back on my standard answer these days: "I'm 74 years old".

Sometimes it just takes a bit of 'thinking outside the box'. At 74, you should have a head start on that

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
inserting wordwrap table causes paragraph break in text	sodiumkpump	Word Tables	1	08-05-2015 06:36 PM
Insert paragraph break before images	jsoule	Word VBA	3	02-25-2015 07:53 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
Records paragraph break	ervilhaman	Mail Merge	14	04-09-2013 02:55 PM
URGENT: Mail 'Merge To New Doc' restarts paragraph numbering at each Section break	JamesF	Mail Merge	0	07-28-2011 07:26 AM