P107 Delete Specified Row(s) or Column(s)

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

107

Delete specified rows or columns

/1 = sSheetStart (by name or number)

/2 = sToDelete (by number)

/3 = bDeleteColumns ("TRUE" or "FALSE")

This special process can delete specific rows or columns from an existing worksheet.

Special Parameters Described in Detail

/1{sSheetStart} Name of the sheet to alter. Required.

/2{sToDelete} Specific column or rows to be deleted. Required.

/3{bDeleteColumns} If set to "TRUE", columns will be deleted; if set to "FALSE", rows will be deleted. Required.

 

Examples:

EXAMPLE 1 Delete Rows 6-8 and 10 from a worksheet