Excel CLng Function (VBA)
How to use the CLng Function (VBA)
This Excel tutorial explains how to use the Excel CLng function with syntax and examples using VBA.
SUMMARY:
The Excel VBA CLng function converts an expression into a Long data type.
For example,
- The VBA Code CLng(22426.55) would return 22427
- The VBA Code CLng(33.955555) would return 34
PURPOSE:
To converts a value to an Long Integer type.
RETURN VALUE:
The CLng function returns a Long Integer value.
SYNTAX:
CLng( expression )
ARGUMENTS:
The CLng function syntax has the following arguments:
- expression: Required. The expression is that you want to convert to a long Integer.
- The "expression" can be any value between -2,147,483,648 and 2,147,483,647
- If "expression" is outside the range of the data type being converted to, an error occurs.
- If "expression" includes any fractions or decimals these are rounded.
- Any fractional parts less than or equal to 0.5 are rounded down to the nearest even number.
- Any fractional parts greater than 0.5 are rounded up.
REMARKS:
- The CLng function can only be used in VBA code in Microsoft Excel.
- The Long data type is a Value data type.
- VBAs hexadecimal notation symbol is "&H"
- The Integer data type can hold integer values between (- 2.1 E+9) and (2.1 E+9)