VBA Proper Case
Good morning,
I have a macro which sorts a lot of data in a spreadsheet I regularly download, and one thing I want to add is changing an upper case column into proper case. None of the vba code I've found online has worked or even really makes sense.
I want to select column N:N and with selection change case to vbProper Case or something along these lines.
Any ideas??
Jemma :-)
Have a look at these lines (May be useful for your case)
Sub Test() Dim str As String str = StrConv("HELLO WORLD", vbProperCase) MsgBox str End Sub
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
or per YasserKhalil's suggestionSub ConvertPropeCase() For Each cl In Selection cl.Value = WorksheetFunction.Proper(cl.Value) Next cl End Sub
Sub ConvertPropeCase() For Each cl In Selection cl.Value = StrConv(cl.Value, vbProperCase) Next cl End Sub
Isskint, i get satisfaction out of helping others
Instead of saying thanks or even didn't say a word.. You add bad reputation for my post !! that's the first time I see such a situationObviously this was aimed at wasting my time. Hilarious.
You can explain your issue in more details and upload sample of your workbook
And don't forget that I am not obliged to post a reply to your thread .. I was just trying to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks