Changing lower case to upper case letters

hawkeye

New member
Joined
Sep 24, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Microsoft 365
My wife has a spreadsheet that is all in lower case. She would like to change the people's names to all uppercase. Is this possible?
Thanks in advance. We are on Windows 10 if that matters
 
Here is a VBA solution

Code:
Option Explicit


Sub UpperCase()
    Dim c As Range, rng As Range
    Set rng = Range("A1:I9")  'change this to your range
    For Each c In rng
        c.Value = UCase(c)
    Next c
End Sub



Standard Module
How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


To run the Excel VBA code:
Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button
 
Back
Top