Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-14-2025, 07:55 AM
vivka vivka is offline VBA format text before colon issue with square bracket Windows 7 64bit VBA format text before colon issue with square bracket Office 2016
Expert
 
Join Date: Jul 2023
Posts: 302
vivka is on a distinguished road
Default

Hi, Shelley Lou! Although I didn't check it (because I don't have a text sample, only its picture), try this line:
Code:
If oRng.Characters(1).Start = oRng.Paragraphs(1).Range.Characters(1).Start Or oRng.Characters.First.Previous = "[" Then
This will be helpful if the string to find is not inside the paragraph.
Besides, I would insert

Code:
On Error Resume Next
at the beginning of the code to prevent error 91 popping up in case the range to find begins the active doc, because in that case the chr before the rng's 1st chr does not exist.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Format text before colon bold not including square bracket/bracket Shelley Lou Word VBA 3 09-26-2024 09:12 AM
VBA format text before colon issue with square bracket VBA quote mark to insert after square bracket Shelley Lou Word VBA 13 06-25-2021 12:41 AM
VBA format text before colon issue with square bracket Delete blank paragraph below bold, end square bracket Dave T Word VBA 2 04-28-2019 11:00 PM
VBA format text before colon issue with square bracket Remove repeated number after square bracket jeffreybrown Word VBA 8 12-04-2018 06:01 PM
Word 2010 - Remove square-bracket encased string in large document IntestinalWorm Word 1 06-20-2017 01:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:30 PM.


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