Excel: worksheetFunction.transpose

Writing a VBA array vertically to cells

worksheetFunction.transpose creates a «vertical» version of a VBA array so that the array's values can be written downwards on a worksheet.

option explicit

sub main() ' {

    dim days   as variant : days   = array("Mon", "Tue", "Wed", "Thu", "Fri")
    dim region as variant : region = array("South", "East", "West", "North" )

    cells(3,2).resize(5,1).value = worksheetFunction.transpose(days)
    cells(2,3).resize(1,4).value = region

end sub ' }

Github repository about-MS-Office-object-model, path: /Excel/WorksheetFunction/transpose/write-array-to-cells.bas

Compare with writing a 2D array to a worksheet.