Change Font/Style of All Headers

[PYE]

Headers are currently linked from Excel, but for whatever reason, the first n characters are a different size, font, and are bolded versus the remaining.

Example: JOHNSON (is bold, all caps, calibri) Space Center (is Arial 10, not bold, not caps). All of this is within a linked DOCVARIABLE (merge).

Could someone please provide the code to go through each header section and change the font.

Arial, 10pt., Bold, Small Caps

Thanks!!!

[Tinbendr]

Look at this article. (http://word.mvps.org/faqs/macrosvba/FindReplaceAllWithVBA.htm)

Post back if you need more help.