Overflow 6 in code - why, and how to solve?

  • Dear everyone. I have coded the following, but I cannot get it to run...I get the errormessage "runtime error 6: overflow". Can anyone help me figure out how to make it work. This is my code:




    Best regards,


    Maria Wieborg

  • Re: Overflow 6 in code - why, and how to solve?


    ... I think the error is in my function y, because when I try debugging, the overflow statement is in this function, but I still cannot see what is wrong? If anyone could please help me :)

  • Re: Overflow 6 in code - why, and how to solve?


    Code
    For i = 0 To 20 
                T = Cells(5, i + 3).Value 
                y1 = y(Phi, Kr, Ke, Br, Be, Rho, rr, e1, T) 
                Cells(6 + j, i + 3) = y1 
            Next


    If Cells(5,i+3) contains a very small number, the divison in y1 by Tau (T) might cause an overflow error.
    It would probably occur if T = 0, but is read as a very small number.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!