Visual Basic for Applications Reference
Mod Operator
Used to divide two numbers and return only the remainder.
Syntax
result**=number1Mod**number2
The Mod operator syntax has these parts:
| Part | Description |
| result | Required; any numeric variable. |
| number1 | Required; any numeric expression. |
| number2 | Required; any numeric expression. |
Remarks
The modulus, or remainder, operator divides number1 by number2 (rounding floating-point numbers to integers) and returns only the remainder as result. For example, in the following expression, A (result) equals 5.
A = 19 Mod 6.7
Usually, the data type of result is a Byte, Byte variant, Integer, Integer variant, Long, or Variant containing a Long, regardless of whether or not result is a whole number. Any fractional portion is truncated. However, if any expression is Null, result is Null. Any expression that is Empty is treated as 0.