title: Convert an entire range to uppercase without looping through all the cells
body: <p>right now I'm using the following code to convert a list of ticker symbols from lowercase to upper case letters:</p>
  
  <pre><code>Dim Tickers As String
  Dim n As Integer
  For n = 2 To Last
      Tickers = UCase(W.Cells(n, 1).Value)
      W.Cells(n, 1).Value = Tickers
  Next n
  </code></pre>
  
  <p>Is there a method I can use to convert the whole range in one line?  something like:</p>
  
  <pre><code>Range("A1:A20").convertouppercasesomehow
  </code></pre>