MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

overflow problem

  Asked By: Lucina    Date: Jan 13    Category: MS Office    Views: 641

I have a variable c of currency type (with value around 5 billion)
when I use command
d= c mod 1000

d is long type
I get overflow error. Is there a way to get around it?



1 Answer Found

Answer #1    Answered By: Fadwa Ahmed     Answered On: Jan 13

Yep, looks as though you've hit the limit.

You probably need to do it from first principles:

c - Int(c / 1000) * 1000

Didn't find what you were looking for? Find more on overflow problem Or get search suggestion and latest updates.