title: Call a worksheet in a different workbook than activesheet: error
body: <p>I need to call a worksheet(&quot;Base&quot;) in a different workbook(&quot;draft1&quot;), while working on my active sheet. Both the active workbook(&quot;draft2&quot;) and the workbook that need to be called have a worksheet &quot;Base&quot; but I specifically need the worksheet in draft1.
  The following works, however uses the &quot;Base&quot; sheet in the active sheet (since workbook hasn't been specified) and returns no error.</p>
  <pre><code>Set C = Worksheets(&quot;Base&quot;).Range(&quot;A1&quot;).Offset(0, i)
  </code></pre>
  <p>However, when I use the following, I get a compilation error and the macro is stopped midway. Both files are saved in the same folder so this shouldn't be a problem. However, even when I call the workbook with its full address, the same error is returned. Do I perhaps need to shift the macro to the personal project thing so it can use other workbooks?</p>
  <pre><code>Set C = Workbooks(&quot;draft1.xlsx&quot;).Worksheets(&quot;Base&quot;).Range(&quot;A1&quot;).Offset(0, i)
  </code></pre>
  <p>Help would be appreciated!</p>
  <p><strong>EDIT</strong><br/>
  Here's the code snippet for the above-</p>
  <pre><code>Sub CreateNewMonth()
  Dim i As Integer, C As Range
  Application.ScreenUpdating = False
  i = 1
  Do While i &lt;&gt; 0
      Set C = Worksheets(&quot;Base&quot;).Range(&quot;A1&quot;).Offset(0, i)
      'Workbooks(&quot;draft1.xlsx&quot;).
      If IsEmpty(C) = False Then
          .
          .
          .
      End If
  Loop
  End Sub
  </code></pre>
  <p>There isn't any error with the loop since it is working just fine with the active sheet's &quot;Base&quot;.</p>