![]() |
#1
|
|||
|
|||
![]()
Hi everyone
Resolved. This is an old macro that just removes the trailing space for text (quick clean up). But it is not working Windows 10 Office 365 Business Standard. A Rny ideas how to make it work? - It doesn't error it just doesn't remove the trailing space in the Word document. Sub Purge_Trailing_Space() Dim s As String On Error Resume Next With ActiveDocument If Len(.Range) = 1 Then Exit Sub s = .Characters.Last.Previous While s = " " Or s = Chr(13) Or s = Chr(11) .Characters.Last.Previous = "" s = .Characters.Last.Previous Wend End With End Sub Janine Last edited by jec1; 08-01-2021 at 03:15 PM. |
|
![]() |
||||
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 |