Is there a way to capitalize everything within a workbook?

  • Thread starter Thread starter Rand
  • Start date Start date
R

Rand

I'm working on several workbooks and I would like to know
if there is a way to capitalize an entire wookbook? I've
tried to use the: "=UPPER" command and I can do it for
single cells but it doesn't work for multiple cells? Or
is it possible to capitalize an entier column in a
workbook?

Lost and confused!
 
There are macros that can do it. Maybe the simplest way would be to goto
some other sheet and use

=UPPER(Sheet1!A1)

then copy it down as far as needed, then copy n' paste (special>values) over
the original located on sheet 1.
 
Don't know why but this is a general idea.

Sub makeupper()
For Each ws In Worksheets
For Each c In ws.UsedRange
c.Value = UCase(c.Value)
Next c
Next ws
End Sub
 
Back
Top