|
|
#1
02-28-2024, 02:55 AM
|
|||
|
|||
VBA MoveStartUntil cSet query
I have a query regarding the use of cSet. This is just a line from a bigger macro. This line looks for a character before a space (a series of case words) . Can a cSet look for more than one thing at a time - I've been trying to add to look before a space or a non breaking space - I've added the usual ^s or Chr(160) after the space, same within square brackets etc., a line of code on its own but nothing seems to be working. Where am I going wrong?
Code:
Rng.MoveStartUntil cSet:=" ", count:=-10 
|
|
|
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 |
Windows 10 
Office 2016
Threaded Mode