View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
papou[_2_] papou[_2_] is offline
external usenet poster
 
Posts: 112
Default Lowercase to uppercase

Hello Deborah
How about a little macro to do this?
Sub ChangeIntoUpper()
For Each c In ActiveSheet.UsedRange
c.Value = UCase(c.Value)
Next c
End Sub

HTH
Cordially
Pascal

"workingwoman" a écrit dans le
message de news: ...
Can I change a worksheet with all lowercase to uppercase?
--
Deborah Motte