title: Long Datatype Overflow
body: <p>I am trying to do some prime factorisation with my VBA excel and I am hitting the limit of the <code>long</code> data type - </p>
  
  <blockquote>
    <p>Runtime Error 6 Overflow </p>
  </blockquote>
  
  <p>Is there any way to get around this and still stay within VBA? I am aware that the obvious one would be to use another more appropriate programming language.</p>
  
  <hr>
  
  <p><a href="https://stackoverflow.com/a/297480/1146308">Lance's solution</a> works in so far that I am able to get the big numbers into the variables now. However, when I try to apply the <code>MOD</code> function - bignumber <code>MOD 2</code>, for example - it still fails with error message </p>
  
  <blockquote>
    <p>Runtime Error 6 Overflow</p>
  </blockquote>