Change Case

[Gary Ballance]

I have the same question. Is there an easy way to change
data in an entire spreadsheet from lower to uppercase?

 

[J.E. McGimpsey]

Take a look at David McRitchie's Upper() macro:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

But PLEASE reconsider! ALL CAPS IS A PAIN IN THE NECK TO READ!

 

[Don Guillett]

try
Sub ucaseall()
For Each c In ActiveSheet.UsedRange
c.Value = UCase(c)
Next
End Sub