Change Case

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

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!


In article ,
"Gary Ballance" wrote:

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

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

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