![]() |
|
#1
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
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 |
![]() |
judyn | Word | 5 | 10-18-2012 03:09 PM |
![]() |
jgriffin | Word | 2 | 06-24-2009 04:05 PM |