title: Waiting in Excel Macros
body: <p>I am recording an Excel Macro where I would like it to wait half a second before switching to the next value. I am plotting changes to a graph, and right now it just storms through the values so you dont really see any changes. I would therefor like it to wait half a second before moving on. </p>
  
  <p>The Macro Im using looks like this:</p>
  
  <pre><code>Sub Macro2()
  ' Macro2 Macro
      Range("C1").Select
      ActiveCell.FormulaR1C1 = "1"
      Range("C1").Select
      ActiveCell.FormulaR1C1 = "2"
      Range("C2").Select
  End Sub
  </code></pre>
  
  <p>Now I would love to do something like the following but it doesnt work. </p>
  
  <pre><code>Sub Macro2()
  ' Macro2 Macro
      Range("C1").Select
  ActiveCell.FormulaR1C1 = "1"
  Range("C1").Select
  Sleep (100)
  ActiveCell.FormulaR1C1 = "2"
  Range("C2").Select
  Sleep (100)
  End Sub
  </code></pre>
  
  <p>Help please? I'm on a Mac Office Excel 2011.</p>