Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2024, 10:37 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


Shelley Lou, If I correctly understand your aims, I'd use characters, not words because of the MS Office's unusual idea of a word.

Since I have no opportunity to test the following, try experimenting with the code:

Code:
If sLastWord = "]" Then msgbox sLastWord.range.characters.first.previous
Reply With Quote
  #2  
Old 02-29-2024, 12:53 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

Hi Vivka, I will certainly play around with that line of code so many thanks. I do have another post I need to solve where this query came from originally called Adding Punctuation to End of Paragraphs which has the full code within it. I'm just having issues trying to get the code to look before the square bracket to see if there is any punctuation, if there is move on to next, if not add punctuation. Many thanks for your help on this query though, much appreciated.
Reply With Quote
Reply



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 01:52 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