Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-28-2024, 07:00 AM
vivka vivka is offline VBA MoveStartUntil cSet query Windows 7 64bit VBA MoveStartUntil cSet query Office 2016
Expert
 
Join Date: Jul 2023
Posts: 302
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IFS query (I think) ronsar Excel 1 12-06-2018 09:04 AM
VBA MoveStartUntil cSet query 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
VBA MoveStartUntil cSet query 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft