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 |
optional, default=wksInsertDown |
Example
This example demonstrates how to insert a range, shifting existing cells right of the range.
WksRange. Insert (Direction:=wksInsertRight)
Used by: WksRange object