Skip to main content
Version: 20 R7 BETA

VP DELETE COLUMNS

VP DELETE COLUMNS ( rangeObj : Object )

ParameterTypeDescription
rangeObjObject->Range object

Description

The VP DELETE COLUMNS command removes the columns in the rangeObj.

In rangeObj, pass an object containing a range of columns to remove. If the passed range contains:

  • both columns and rows, only the columns are removed.
  • only rows, the command does nothing.

Columns are deleted from right to left.

Example

To delete columns selected by the user (in the image below columns B, C, and D):

use the following code:

VP DELETE COLUMNS(VP Get selection("ViewProArea"))

See also

VP DELETE ROWS
VP INSERT COLUMNS
VP INSERT ROWS