title: Why cannot I ReDim an array with index of LongPtr or LongLong in Excel 2016 VBA
body: <p>I am used to use the following code on Excel 2010 (Windows 7 64-bit), and It works good.</p>
  
  <pre><code>Sub code_on_2010()
    Dim i As Long
  
    i = InputBox("input integer number")
    ReDim a(i) As Variant
    '....
  End Sub
  </code></pre>
  
  <p>Recently, I upgrade my PC to Windows 10(64-bit) and Excel 2016(64-bit).  As I know the new type name for 64-bit Long integer type, I rewrite my code as below:</p>
  
  <pre><code>Sub code_on_2016_with_LongPtr()
    Dim i As LongPtr
  
    i = InputBox("input integer number")
    ReDim a(i) As Variant
    '...
  End Sub
  </code></pre>
  
  <p>It returns a <code>Type mismatch (Error 13)</code> Error.</p>
  
  <p>Even I replace the LongPtr with LongLong (as below), it returns <code>Type mismatch</code> error, too.</p>
  
  <pre><code>Sub code_on_2016_with_LongLong()
    Dim i As LongLong
  
    i = InputBox("input integer number")
    ReDim a(i) As Variant
    '...
  End Sub
  </code></pre>
  
  <p>Could anybody tell me why I cannot ReDim an array with index of LongPtr or LongLong type in Excel 2016 VBA?</p>