Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-31-2021, 09:15 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 Trim trailing space macro stopped working

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.
Reply With Quote
 



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 03: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