![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
IFS query (I think) | ronsar | Excel | 1 | 12-06-2018 09:04 AM |
![]() |
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 |
![]() |
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 |