title: How to output the result on different cell? (VBA Excel 2007)
body: <p>I have calculated some values and there should be two results. I want to display these result in two different cell.</p>
  
  <p>When I have changed A1 or A2 value, excel is stopped. Is there anyway I can display the values?</p>
  
  <pre><code>Sheet1 
  Private Sub Worksheet_Change(ByVal Target As Range)
     Call DisplayResult 
  End Sub
  
  Module1 
  Sub DisplayResult() 
       Range("A3").Value = Range("A1").Select.Value + Range("A2").Select.Value     
       Range("B3").Value = Range("B1").Select.Value + Range("B2").Select.Value 
  End Sub
  </code></pre>