On Mon, 18 Feb 2013 12:01:41 +0100, "Charlotte E." wrote:

How come MOD provides different answers, depending on if you're using it
in a spreadsheet or in a VBA-code???

The "defintions" are diferent

Worksheet: Returns the remainder after number is divided by divisor.
VBA: Used to divide two numbers and return only the remainder BUT firts rounding floating-point numbers to integers.



How to make the VBA-code provide the result, that I want?



Use this equivalent: n - d*INT(n/d)