Using Proper function to Format Worksheet

Hot Topic

Runtime error '13' - type mismatch problem! Again...
Using parts of a cell value as a variable?
Help Deploying VBA changes across hundreds of Word Temlates
VBA resources
HTTP request - simple problem
whats wrong with this code?
opc
sorting in ListView
Open PDF file
Access 2003 Long Binary Data

Microsoft ISV

Macro stops running after a certain time, excel limitation???
VBA sheet using registered dll functions across a network
CreateProcessA problem - no DOS windows appearing
Getting Data of HTML page
Setting ChartObjects Properties throws Run-time Error '1004'
"Bizzare" Sendkey Code in Excel
how to open read only file that will be open for notification in word?
Is There a VBA Documenter
MS Office document and image writer print driver
Wanted - VBA Developer Banking Zurich

Using Proper function to Format Worksheet

Is there a way to use the "Proper" function to format an entire worksheet. I want to convert a mainframe download in all caps to the "Proper" method (i.e. JAMES BROWN -> James Brown). I assume I will need to write a macro using VBA. Does anyone have any thoughts on how this is done

Thanks!

Answer this question

Using Proper function to Format Worksheet

  • dr.acv

    Dim cc As Variant
    For Each cc In Sheet1.UsedRange.Cells
    cc.Value = Application.WorksheetFunction.Proper(cc.Value)
    Next cc

  • Sianspheric

    Thanks! Works like a charm. I haven't written any VBA for Excel - or if I have it's been 7+ years ago.
  • Using Proper function to Format Worksheet
Answer this question