Visual Basic for Applications/Transfer Data to the Worksheet

Summary
'''This page gives an overview of transferring data from VBA to the worksheet. The code module includes procedures for transfer of both one and two dimensional arrays to the sheet. Brief code line notes are also included for single line and block transfers'''.

Contents of the Module

 * The module works best if kept intact.  The top procedure has code lines to run the other procedures.   Just de-comment the code that you intend to run, and add comment marks to the lines that are not intended to run.
 * The code procedures include normal or transposed transfers from two dimensional arrays.
 * In addition, the handling of one dimensional arrays has been included. They can be transferred into a column or a row.
 * The placement position can be specified in every case.
 * Note that the selected worksheet will be cleared on each run, so select a worksheet for output that will not remove essential data.
 * ConvColAlphaToNum and ConvColNumToAlpha are included to convert worksheet column references between the alpha and numeric formats.
 * Additional procedures have been added for clearing and formatting text and the sheet.