Changing a list of word to upper case

[Bikram]

Greetings to all,


I am working on a document where I have to change the heading to uppercase and while doing so, I have to be careful because I cannot change any preposition like the, on, in, with, a, and, etc. So, what I am really trying to do is 'Change all the first letters of the word to uppercase excluding some words listed above. I have attached a sample file, plz have a look and suggest a solution. Thanks in advance.

[gmayor]

See the True Title Case example code on my web site at VBA Code Examples (2)

[Bikram]

Thanks, sir for the reply. The code that you have provided exactly met my needs.