Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2021, 11:32 PM
jec1 jec1 is offline Trim trailing space macro stopped working Windows 7 32bit Trim trailing space macro stopped working Office 2013
Advanced Beginner
Trim trailing space macro stopped working
 
Join Date: Jan 2012
Posts: 84
jec1 is on a distinguished road
Default

Every paragraph - this is really an old macro - must have left it half finished...

Every para - I just want it to run through the document text top to bottom - and remove trailing space - then call my Table Cell macro.

Below macro seems to work okay.

Sub jec_RemoveTrailingWhitespaceCR(control As IRibbonControl)


'
' RemoveTrailingWhitespace()
' This macro uses find and replace to remove trailing whitespace from the end of all the
' paragraphs in a document. The macro operates on whatever text is currently selected.
'
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = "^w^p"
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
.Execute Replace:=wdReplaceAll
End With
Call jec_Purge_Trailing_SpaceTableCells
End Sub
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Function key F4 stopped working coffent Excel 7 11-15-2020 11:15 AM
Data Entry - Getting spreadsheets back with excess space but the TRIM function doesn't work jhato160 Excel 5 06-17-2016 04:06 AM
Save to PDF stopped working RzB Excel 6 06-26-2014 03:40 AM
Trim trailing space macro stopped working Word stopped working judyn Word 5 10-18-2012 03:09 PM
Trim trailing space macro stopped working Tab key stopped working in Word jgriffin Word 2 06-24-2009 04:05 PM

Other Forums: Access Forums

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