Thread: Convert text to all caps
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Richard Schollar[_2_] Richard Schollar[_2_] is offline
external usenet poster
  
Posts: 29
Default Convert text to all caps
Hi Patrick

For Each c in
Range("B3:M2500").SpecialCells(xlCellTypeConstants ,xlTextValues)
c.Value = UCase(c.Value)
Next c


Richard


"Patrick C. Simonds" wrote in message
...
Is there any way to convert all text, in the range B3:M2500, to all
capital letters from within a macro?

Reply With QuoteReply With Quote