Simple VBA devision problem

[phillip harrison]

Hi there

I've got a problem which envolves simple devision with decimals but VBA
is rounding it to an integer.

My code is this:

NumBound = MaxValue / SharedValues

All 3 values are defined as Long

The problem comes when MaxValue is, say 8113.567235, SharedValues is,
say 18236 and thus NumBound should equal 0.4449203 but comes up as 0.

This then results in my further calcuations producing an error as I have
to devide by NumBound, i.e. 0 which is not possible.

Any help would be greatly appreciated

Thanks

Phillip

 

[Wild Bill]

Use Double instead of Long

Look at Data Type Summary if your version has this in Help

 

[phillip harrison]

ahhhhh .. grand.. thanks