title: What is the maximum value for row and column offsets in VBA for Excel 2010?
body: <p>I know a similar question has been answered here:</p>
  
  <p><a href="https://stackoverflow.com/questions/2146283/what-is-the-maximum-value-for-row-and-column-range-offset-in-vba-excel">What is the maximum value for row and column Range offset in VBA/Excel?</a></p>
  
  <p>However, that error seemed to be related to the number of rows in the worksheet in Excel 2003. Since I am running Excel 2010 (with 65,536 rows), I don't think my error is related to my worksheet size.</p>
  
  <p>Here is the line of code that is giving me Run-time error '6' Overflow:</p>
  
  <pre><code>Range("OutputStart").Offset(1 + (iCounter1 - 1) * iDataPoints * 26 + iCounter2 * iDataPoints, 0).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
  </code></pre>
  
  <p>iCounter1 is an integer and its value is 13
  iDataPoints is an integer and its value is 103
  icounter2 is an integer and its value is 7</p>
  
  <p>The result of the row offset calculation is 32,858, which indicates an Integer data type issue. Is the row offset limited to Integer data types? If so, is there any way to change that limitation to Long (or another data type)?</p>
  
  <p>Thanks for any help you can provide!</p>
  
  <p>Will</p>