title: VBA - SendKeys "Enter" Alternative for Mac Excel 2011
body: <p>I'm attempting to run a macro in Excel containing the following VBA code:</p>
  
  <pre><code>Range("Results").ClearContents
  For counter = 1 To 40
          Range("constant") = -0.04 + counter * 0.005
          Solve
          Application.SendKeys ("{Enter}")
          Range("Results").Cells(counter, 1) = ActiveSheet.Range("constant")
          Range("Results").Cells(counter, 2) = ActiveSheet.Range("portfolio_sigma")
          Range("Results").Cells(counter, 3) = ActiveSheet.Range("portfolio_mean")
          Range("Results").Cells(counter, 4) = ActiveSheet.Range("x_1")
          Range("Results").Cells(counter, 5) = ActiveSheet.Range("x_2")
          Range("Results").Cells(counter, 6) = ActiveSheet.Range("x_3")
          Range("Results").Cells(counter, 7) = ActiveSheet.Range("x_4")
  Next counter
  </code></pre>
  
  <p>at runtime, I receive an error stating that SendKeys isn't available on Excel for Mac. What is the most efficient alternative / workaround for this?</p>