VBA : Overflow error

Question

I have an error i don't understand why

I have a function i didn't touch (without error) and now it's didn't work... My function has just on line

I tried the function CDbl() and use the double type variable

I get an Overflow error

Number = 1341.0937961001

NbDecimal = 2

Function Truncate(Number As Double, NbDecimal As Integer) As Double
    Truncate = Int(Number * 10 ^ NbDecimal) / (10 ^ NbDecimal)
End Function 'Error here : Overflow

I need help

I tried running this with the values you provided and it works. So can you supply the code you use to run this? — 99moorem
– 99moorem, Commented Jan 29, 2016 at 11:36
I, too, cannot reproduce the error using the code and values in your post. — Ron Rosenfeld
– Ron Rosenfeld, Commented Jan 29, 2016 at 12:58
Sorry the problem has not this function but the next. I resolve the problem — Shimo
– Shimo, Commented Jan 29, 2016 at 14:54

Charles Williams · Accepted Answer · 2016-01-29 15:21:15Z

1

It will overflow when Number * 10 ^ nbDecimal exceeds 32767 because thats the largest number VBA will store in an integer.

Actually I am wrong: it will only overflow if you use CInt() rather than Int()

edited Jan 29, 2016 at 15:21

answered Jan 29, 2016 at 12:00

Charles Williams

23.6k5 gold badges40 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ron Rosenfeld Over a year ago

I cannot reproduce that using his code. With his code and his values, Number * 10 ^ nbDecimal = 134109.37961001 and the code runs without error. I would expect a problem if nbDecimal > 32767 (Excel 2016)

Doug Coats · Accepted Answer · 2016-01-29 12:27:01Z

0

To add to What Charles Williams was saying, you might want to change your data type to Long.

answered Jan 29, 2016 at 12:27

Doug Coats

7,2179 gold badges32 silver badges55 bronze badges

Collectives™ on Stack Overflow

VBA : Overflow error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related