title: Excel - slow VBA execution of simple loop
body: <p>I just want to make sure that text inside a column is changed into uppercase.</p>
  <p>For this I am using the following code</p>
  <pre><code>Private Sub Worksheet_Activate()
  
  Dim cell As Range
  
  For Each cell In Range(&quot;$G$6:$G$200&quot;)
      cell.Value = UCase(cell.Value)
  Next cell
  
  End Sub
  </code></pre>
  <p>In this case the loop runs over ~200 cells but it already takes about 15 seconds to execute. Any ideas?</p>