Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-28-2024, 02:55 AM
Shelley Lou Shelley Lou is offline VBA MoveStartUntil cSet query Windows 10 VBA MoveStartUntil cSet query Office 2016
Expert
VBA MoveStartUntil cSet query
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default 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
Reply With Quote
 



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 04:09 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