I write the follow code:

Code:
    Dim a As Double
    
    a = 20001 * 8
It will have overflow error, however, as 20001 * 8 = 160008, if I assign a directly to 160008, it will be fine, i.e.

Code:
   a = 160008
I think the problem is come from the * operator, but how could I solve this?? I really need to handle such a big value..