CapitalizeNamesOfDays Property Example
This example sets Microsoft Excel to capitalize the first letter of the names of days.
With Application.AutoCorrect .CapitalizeNamesOfDays = True .ReplaceText = True End With