Microsoft Office Forums - View Single Post - [Solved] VBA MoveStartUntil cSet query

Thread: [Solved] VBA MoveStartUntil cSet query

View Single Post

Old

02-28-2024, 07:00 AM

vivka

vivka is offline

vivka uses Windows 7 64bit

Windows 7 64bit vivka uses Office 2016

vivka uses Office 2016

Office 2016

Expert

Join Date: Jul 2023

Posts: 293

vivka is on a distinguished road

Default

Both lines will work:

Code:

Rng.MoveStartUntil cSet:=" " & Chr(160), count:=-10

and

Code:

Rng.MoveStartUntil cSet:=Chr(32) & Chr(160), count:=-10

To see the result, use

Code:

Rng.Select

or

Code:

msgbox Rng

Reply With Quote