VBA Measuring the length of strings Use the LenB function to determine the number of bytes in a string
Example
Const baseString As String = "Hello World"
Dim byteLength As Long
byteLength = LenB(baseString)
'byteLength = 22
Const baseString As String = "Hello World"
Dim byteLength As Long
byteLength = LenB(baseString)
'byteLength = 22
