Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 01-12-2022, 10:21 PM
Guessed's Avatar
Guessed Guessed is offline VBA to select a specific font type Windows 10 VBA to select a specific font type Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Good call Graham. Old age already biting deep here.

If you are going to include spaces then it will probably find spaces between lower case letters too. Assuming there are no double spaces in the document, you might ask the find to only return hits with at least two or three found characters
Code:
.Text = "[A-Z ]{2,}"
or
.Text = "[A-Z ]{3,}"
I would probably expand this to a minimum of three characters to avoid words that have an initial cap preceded by a space unless this is what the OP really wanted.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to select a specific font type Merging two Word documents: 2nd document not maintaining original font type and font size Swarup Word 31 08-28-2018 06:55 PM
Macro that swaps out font type namedujour Word 3 08-01-2018 01:27 PM
Font Type changes with change in language animex Word 1 09-08-2017 05:23 PM
VBA to select a specific font type Type 1 font d4okeefe Word 3 02-09-2016 01:16 AM
Mysterious Font Type Symbol curiousUser Word 2 08-18-2014 05:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 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