Insert

Insert shifts the current worksheet cells down or to the right and inserts blank cells in their place.

Syntax

object.Insert( Direction )

Parameter	Type	Required/ Optional	Default	Description
Direction	wksInsert	Optional	wksInsertDown	This specifies the direction to which the cells should be shifted.

Example

This example demonstrates how to insert a range, shifting existing cells right of the range.

WksRange.Insert(Direction:=wksInsertRight)

Used by: WksRange object