title: Get values from other sheet using VBA
body: <p>I want to get values from other sheets. </p>
  
  <p>I have some values in Excel (sheet2) for example:</p>
  
  <pre><code>    A  B  C  D
      -  -  -  -  
  1 | 2  5  9  12
  2 | 5  8  4  5
  3 | 3  1  2  6
  </code></pre>
  
  <p>I sum each column in row 4.</p>
  
  <p>I'm working with these values in sheet2 but I want to get the result in sheet1.</p>
  
  <p>When using my code in sheet2 I get the correct answer but when I try to use it in a different sheet I get the result of the values corresponding to the current sheet cells and not to sheet2.</p>
  
  <p>I'm using <code>With Application.WorksheetFunction</code>.</p>
  
  <p>How can I set sheet2 as the active sheet?</p>