VBA coding for forcetitle case

D

donna

Hello there,

I am trying to write a code for my heading which I want to change to title
case. I would obviously, like to keep "and", "on","the" words in lower case
if they are not first word(s)

Any help

Thanks
 
W

Word Heretic

G'day "donna" <[email protected]>,

I manually produced my own array of TrivialWords. I use this for
several things:

Stripping out guff for auto bookmark names
Decaps on Title Case.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


donna reckoned:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep First Letters, with exceptions 0
VBA word change keys 0
Drop down list control value in vba 2
Need help modifying code 0
Word doc keeps changing to ALL CAPS 0
Autonumber field in Excel that behaves the same as Access 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Weekly Report 2

Top