title: Getting error for : Application.Goto Workbooks("BOOK2.XLS").Sheets("Sheet1").Range("E4:F12")
body: <p>I am getting a run time error '9' script out of range when trying to run the code</p>
  
  <pre><code>Application.Goto Workbooks("BOOK2.XLS").Sheets("Sheet1").Range("E4:F12")
  </code></pre>
  
  <p>I am using Excel 2010.
  I can see many users are able to use <a href="http://support.microsoft.com/kb/291308" rel="nofollow">this code</a> successfully, but why am I not getting it to work?
  I am writing the code in book1 and trying to copy the data from book2:</p>
  
  <pre><code>Sub copy()
  Application.Goto Workbooks("BOOK2.XLS").Sheets("Sheet1").Range("E4:F12")`
  End Sub
  </code></pre>