title: Run-Time Error 6: Overflow Excel 2010
body: <p>I have a report in excel that brings in data from Access 2010. When I run it, it gives me an overflow error at <code>numRecords = .Range(.Cells(2, 3), .Cells(2, 3).End(xlDown)).Count</code>.</p>
  
  <pre><code>Dim numRecords As Integer
      Dim row As Integer
      Dim numListed As Integer
      Dim col As Integer
      Dim deliveryMethod As String
      Dim col2 As Integer
      Dim numCol As Integer
  
  With Worksheets("Raw Export")
      numRecords = .Range(.Cells(2, 3), .Cells(2, 3).End(xlDown)).Count
      numCol = .Range(.Cells(1, 1), .Cells(1, 3).End(xlToRight)).Count
  End With
  </code></pre>
  
  <p>I tried changing numRecords as Long but it just moved the error. Any tips would be great.</p>