/ Operator

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Used to divide two numbers and return a floating-point result.

Syntax

result = number1**/**number2

The / operator syntax has these parts:

Part	Description
result	Required; any numeric variable.
number1	Required; any numeric expression.
number2	Required; any numeric expression.

Remarks

The data type of result is usually a Double or a Double variant. The following are exceptions to this rule:

If	Then result is
Both expressions are Byte, Integer, or Single expressions,	a Single unless it overflows its legal range; in which case, an error occurs.
Both expressions are Byte, Integer, or Single variants,	a Single variant unless it overflows its legal range; in which case, result is a Variant containing a Double.
Division involves a Decimal and any other data type,	a Decimal data type.

One or both expressions are Null expressions, result is Null. Any expression that is Empty is treated as 0.

Example

This example uses the / operator to perform floating-point division.

Dim MyValue
MyValue = 10 / 4    ' Returns 2.5.
MyValue = 10 / 3    ' Returns 3.333333.