Function Array Others Class

FormatVariantMatrix

Format the values from a two-dimensional array of variant values into a tabular format, returning the result as a String. The Justify Codes are those recognized by the JustifyText function. They are applied to each cell (individual value) within the array.

Signature (Visual Basic / VBA)

Public Function FormatVariantMatrix( _
      ByRef vFm() As Variant _
    , Optional ByVal vColumnSeparator As Variant _
    , Optional ByVal vRowSeparator As Variant _
    , Optional ByVal vJustifyCodes As Variant _
    ) As Variant

Notes & Version History

Remarks Assume that the elements of a variant matrix (a two-dimensional array of variant values where the first dimension represents the column or type of information and the second dimension represents the row) represent a table which is to be formatted so that columns are aligned in a tabular format. Convert other types of data to String.