title: Method Select of Object '_Worksheet' failed - why?
body: <pre><code>Set mainWB = Workbooks("Copy Paste.xlsb")
  Set mainWS = mainWB.Sheets("Sheet1")
  Set testWS = mainWB.Sheets("Sheet3")
  
  mainWS.Select
  </code></pre>
  
  <p>I keep getting an error on the last line in Excel VBA: </p>
  
  <blockquote>
    <p>"Method Select of Object '_Worksheet' failed"</p>
  </blockquote>
  
  <p>Any idea why or how to fix this? Thank you!</p>