When ever I type code from a book it never works. I type it exactly as printed in the book. I found some code that will change my highlighted selection into Proper case but it is giving me a Sub or Function not defined on the Proper.

[VBA]Sub ConvertToProper()
Dim cellObject As Range
For Each cellObject In Selection
cellObject.Formula = WorksheetFunction(Proper(cellObject.Formula))
Next

End Sub[/VBA]