StaSpreadsheet.VariableTypeLength

This property returns/sets the maximum length of the specified variable (if variable type is set to text) as an integer.

Property StaSpreadsheet.VariableTypeLength( _
    VarNo As Long) As Long