Upper Case first letter

[zplugger]

Can I upper case every first letter in a word in Cell A2 with vba.
For example
Tom Hanks 3456 Elm St.

 

[Joe4]

Excel has a built in function named "PROPER" that will do that.
To use it in VBA, see the following: http://www.excel-easy.com/vba/examples/convert-to-proper-case.html

 

[MickG]

Try:-

With Range("A2")
   .Value = Application.Proper(.Value)
End With

 

[zplugger]

Perfect MickG
Thank You

 

[MickG]

You're welcome