title: Excel VBA: 'excel vba run-time error 1004' application-defined or object-defined error
body: <p>I have this line in a module and it keeps spitting up a run-time error 1004 when I try and run it.</p>
  
  <p>Can anyone help?</p>
  
  <p>I'm guessing it's to do with how the Range is referenced, but i'm not sure. This is all new to me.</p>
  
  <pre><code>rngFirst = ThisWorkbook.Worksheets("Still In Progress").Range("G" &amp; 1 &amp; ":G" &amp; lw)
  </code></pre>
  
  <p>Many thanks in advance</p>