Microsoft Office Forums - View Single Post - VBA to select a specific font type

Thread: VBA to select a specific font type

View Single Post

Old

01-12-2022, 09:59 PM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2019

gmayor uses Office 2019

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,106

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

That's embarrassing. I appear to have misread 'upper case' as 'bold'

I guess old age is taking its toll.

Andrew's correction will of course work, but I would be inclined also to include the space character. You can shorten the search string e.g.

Code:

.Text = "[A-Z ]"

See also Replace using wildcards

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote