title: VBA: activating/selecting a worksheet/row/cell
body: <p>Hello Stackoverflowers,</p>
  
  <p>I'm trying to use a button, that first goes to another excel file in a specific directory. While performing something, I want to add a row in a sheet the excel file i'm running the button from.
  To do that, i need to activate a certain row, or cell to use this</p>
  
  <pre><code>ActiveCell.EntireRow.Insert
  </code></pre>
  
  <p>but it keeps telling me: </p>
  
  <pre><code>activate method of range class failed
  </code></pre>
  
  <p>my last trail was this:</p>
  
  <pre><code>Sheet1.Cells(2, 3).Activate
  ActiveCell.EntireRow.Insert
  </code></pre>
  
  <p>Can anyone tell me how to get this done? i think because i'm in another workbook or something</p>
  
  <p>Thanks</p>