Delete - Automation [WksRange]

The Delete method deletes the cells in the range and shifts the remaining cells either up or to the left.

Syntax

object.Delete( Direction )

Parameter	Type	Required/ Optional	Default	Description
Direction	wksDelete	Required	wksDeleteUp	This specifies the direction to which the adjoining cells shift.

Example

This example demonstrates how to delete a range of cells and shift remaining cells originally right of the range into position.

WksRange.Delete(Direction:=wksDeleteLeft)

Used by: WksRange object