View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger Converse[_2_] Roger Converse[_2_] is offline
external usenet poster
 
Posts: 45
Default Change a range to Uppercase

Hello,

How would I update a range of cells to all uppercase?

My range is:

r = Range("A17:K" & i)

How could I create a loop or something that would change all cells in that
range to uppercase?

Thank you,
Roger