Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-23-2020, 09:57 AM
AlfredStreich AlfredStreich is offline Macro for Find/replace to remove space before Hard Return Windows 10 Macro for Find/replace to remove space before Hard Return Office 2019
Novice
Macro for Find/replace to remove space before Hard Return
 
Join Date: Jan 2020
Posts: 4
AlfredStreich is on a distinguished road
Default

That seems to work. Thanks.

Since I'm still new to working in VBA, what is the purpose of the:
Quote:
Code:
oRng.Characters.First.Text = "~"
      oRng.Characters.First.Delete
      oRng.Collapse wdCollapseEnd
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for Find/replace to remove space before Hard Return Find / Replace hard Carriage Return with Line break. GreenBoy Word 2 03-11-2018 02:32 AM
Macro for Find/replace to remove space before Hard Return Code to find numerical string + space throughout document & replace them with Comma Robert Kay Word VBA 6 02-21-2018 04:41 PM
Macro for Find/replace to remove space before Hard Return Find and Replace with space cheech1981 Word 3 03-29-2017 02:33 PM
Hard page return? markg2 Outlook 0 09-11-2012 08:49 AM
Macro for Find/replace to remove space before Hard Return remove color from find/replace? Cobb78 Word 1 05-26-2012 06:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:45 PM.


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