Excel VBA Len Function

VBA Len Function: The Len function in VBA returns the number of characters in a supplied string or the number of bytes required to store a supplied variable.

Syntax

Len (Expression)

Parameter

Expression (required)- This parameter represents the string or variable of which you want to evaluate the length of.

Return

This function returns the number of characters in a supplied string or the number of bytes required to store a supplied variable.

Example 1

Sub StrLenFunction_Example1()
 'evaluating the length of the string.
 Dim str As String, strLen As Integer
 str = "Welcome to VBA World!"
 strLen = Len(str)
 ' The variable will return 21.
 ActiveCell.Value = strLen
 End Sub 

Output

21

Example 2

Sub StrLenFunction_Example2()
 'evaluating the length of an empty string "".
 Dim strLen As Integer
 strLen = Len("")
 ' The variable will return 0.
 ActiveCell.Value = strLen
 End Sub 

Output

0