View Single Post
Old 09-08-2011, 10:09 PM  
cooldude7
Confirmed User
 
cooldude7's Avatar
 
Industry Role:
Join Date: Nov 2009
Location: Heaven
Posts: 4,306
Quote:
Originally Posted by PromoterX View Post
Code:
Sub Proper_Case()

'This will make the first letter of the text within any selection of 
'cells uppercase.

For Each x In Selection
x.Value = Application.Proper(x.Value)
Next

End Sub
Why re-invent the wheel.... codes out there for the taking people.

i am kind of new in coding so, this is a bot ccomplicated for me.,

thanks for your reply.
cooldude7 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote