title: Excel Run-time error 16 expression too complex
body: <p>I have this basic code in an Excel sheet</p>
  
  <pre><code>For x = 1 To ThisWorkbook.Worksheets("GRP0").Range("D9:D112").Rows.Count
  ' do work here
  Next x
  </code></pre>
  
  <p>though when I execute it gives the error</p>
  
  <pre><code>Run-time error '16':
  
  Expression too complex
  </code></pre>
  
  <p>I'm using Excel 2007 in compatibility mode, the sheet, I believe was made for/in Excel 2003, if that helps. Any ideas as to what is causing the error?</p>