title: Is it possible to allow Integer Overflow in Excel VBA?
body: <p>Pretty simple, but I couldn't find anything by Googling. An example of what I want to happen:</p>
  
  <pre><code>Function myFunc()
      Dim a As Integer
      Dim b As Integer
      Dim c As Integer
  
      a = 20000
      b = 15000
      c = a + b
  
      myFunc = c
  End Function
  </code></pre>
  
  <p>I want myFunc() to return -30536 instead of throwing an overflow exception. I know I could write a function that does that, but I've written a bunch of code for a project with the assumption that overflow was allowed, so I'm hoping there's a quick fix.</p>
  
  <p>EDIT: I don't need help coming up with a function that solves the overflow issue with type conversions. I have one already; I just want to avoid changing hundreds of addition and subtraction operations. I'm also bit frustrated that VBA seems to go out of its way to disable overflow functionality--it should let the user decide if they want to use it or not.</p>