VBA MoveStartUntil cSet query

vivka · #1 02-28-2024, 07:00 AM

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

Shelley Lou · #2 02-28-2024, 07:57 AM

Vivka, you are a superstar, my mistake was trying to put Chr(160) within the quotes.

Within the same code I am working on, if the code below looks for the last character at the end of the paragraph and then inserts something after it, what do I need to change with the line below to look for the character before the last character at the end of a paragraph. I've tried adding ,-1 but that is not working.

Code:

.Words.Last.Previous.Previous.Words(1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IFS query (I think)	ronsar	Excel	1	12-06-2018 09:04 AM
Conditional query ...	LearnerExcel	Excel	5	02-06-2018 01:13 AM
Query and Power Query not working Excel 2016	bl10	Excel	0	07-22-2016 06:25 PM
Baseline query	joday48	Project	6	01-25-2013 09:50 AM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?	mag	Excel	0	10-18-2012 11:15 AM