![]() |
#2
|
|||
|
|||
![]()
Both lines will work:
Code:
Rng.MoveStartUntil cSet:=" " & Chr(160), count:=-10 Code:
Rng.MoveStartUntil cSet:=Chr(32) & Chr(160), count:=-10 Code:
Rng.Select Code:
msgbox Rng |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |