|
<< Click to Display Table of Contents >> Navigation: Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel > Macrocommando Put |
Purpose:
Copying an array of cells from one of the two-dimensional arrays to a worksheet.
General notation:
Put ( ArrayIndex , Row1 , Column1 , Row2 , Column2 , ToFileIndex, ToSheet , Row , Column )
ToFileIndex is the index that refers to the Excel file opened using Open.
If ToFileIndex is assigned the value 0, it can be copied to the workbook file described by the Macro with Write.
ArrayIndex: the array to be copied from
| Row1 | : row number of the top left corner of the array to be copied |
| Column1 | : column number of the top left corner of the array to be copied |
| Row 2 | : row number of the bottom right-hand corner of the series to be copied |
| Column2 | : column number of the bottom right corner of the series to be copied |
ToFileIndex: the workbook to copy to
ToSheet: the destination worksheet in the output workbook
| Row | : row number of the top left corner of destination |
| Column | : column number of the top left corner of destination |