Insert Method

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

Syntax

object.Insert( Direction )

 

Parameter	Type	Description
Direction	wksInsert	optional, default=wksInsertDown

 

Example

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

WksRange.Insert(wksInsertRight)

 

Used by: WksRange object