How to refer to an open workbook in VBA?
<pre><code>Dim test As Range

Set test = Workbooks("MonthlyReport.xlsb").Worksheets("VC Report").Range("C1")
</code></pre>

<p>VBA shows Error 9: Subscript out of range. Why is this? What is wrong with it? The workbook MonthlyReport.xlsb is open.</p>