Spreadsheet.OptimalTextVariableWidths

This function returns longest text value length(s) in data so text variable length can be set to minimum without truncation.

Syntax Parameters Return Value 
Function Spreadsheet.OptimalTextVariableWidths( _
    Optional variables As Variant) As Variant
variables [in,optional]

Type: Variant

Variant