VBA Measuring the length of strings Use the Len function to determine the number of characters in a string
Example
Const baseString As String = "Hello World"
Dim charLength As Long
charLength = Len(baseString)
'charlength = 11
Const baseString As String = "Hello World"
Dim charLength As Long
charLength = Len(baseString)
'charlength = 11
