Microsoft Office Forums - View Single Post - Macro for Find/replace to remove space before Hard Return

Thread: Macro for Find/replace to remove space before Hard Return

View Single Post

Old

01-23-2020, 09:57 AM

AlfredStreich AlfredStreich is offline

AlfredStreich is offline

AlfredStreich uses Windows 10

Windows 10 AlfredStreich uses Office 2019

AlfredStreich uses Office 2019

Office 2019

Novice

The original poster

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