title: Runtime 1004 error for my colleague but not for me
body: <p>The following line of code is resulting in a runtime error 1004 when my colleague runs it but for me it works fine.</p>
  <pre><code>Range(&quot;D4:D&quot; &amp; WorkingRowCount).FormulaR1C1 = &quot;=IFERROR(VLOOKUP(@C1,'Brand lookup'!C1:C3,3,0),&quot;&quot;Error&quot;&quot;)&quot;
  </code></pre>
  <p>For reference, <code>WorkingRowCount</code> is a count of the rows with data in the sheet, and is declared as a Long variable type at the beginning of the macro:</p>
  <pre><code>Dim WorkingRowCount As Long
  WorkingRowCount = Range(&quot;A1&quot;).Offset(Rows.Count - 1, 0).End(xlUp).Row
  </code></pre>