Search notes:

VBA: data type double

Floor

VBA does not have a function named floor.
In order to calculate the floor of a double with VBA, either int(num) or fix(num) is needed.
TODO: In Excel, apperently, there is also a worksheetFunction.floor_math or worksheetFunction.floor_precise() function.

See also

Internally, a date is stored as a double.
The type declaration character for a double is #.
The single and other datatypes.

Index