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 |
Description |
Direction |
optional, default=wksDeleteUp |
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