Copy a range of worksheet cells to another range
Minimum Origin Version Required: 8.0 SR5
Please refer to the page for additional option switches when accessing the x-function from script
See the syntax here.
Clear output columns:
This X-Function can be used to copy the range of cells in a worksheet to another. A row in the source worksheet can be used to set the long names of the columns in the destination worksheet.
The following script command is used to copy the cells range from second row to the end of Sheet1 in Book1 to a new worksheet named Copysheet in the same workbook. And it uses the first row of the source worksheet to set the Long Name of the columns in the destination worksheet. It copies the Units and Comments as well.
wrcopy iw:=[Book1]Sheet1! ow:=[Book1]"Copysheet"! r1:=2 name:=1 label:=UC;