Visual Basic for Applications/Array Data To WorkSheet (1D or 2D)

Summary
This MS Excel VBA code listing transfers data from a one or two dimensional array to a worksheet.

Code Notes

 * Arr1Dor2DtoWorksheet transfers data from an array to a specified worksheet, and at a specified location within it. It takes one-dimensional or two-dimensional arrays, and is able to distinguish between them, prior to the transfer.   Non-array inputs are detected as are arrays that are not allocated. One-dimensional arrays are transferred into a sheet row in all cases.   Two-dimensional arrays are displayed in the same row and column shape as in the array.   There are no facilities in the procedure to transpose data, but procedures exist elsewhere in this series for that purpose.

The VBA Module

 * Copy the entire code listing into a VBA standard module and run the top procedure. Save the worksheet as type .xlsm.  Comment and de-comment lines in the top procedure and adjust parameters to test the main procedure.