Insert Cell

Category

Excel Commands

Description

This command allows you to insert a specified cell in Excel. Use this command when you want to insert a specific cell from the current sheet.

Parameters

Instance Name

Enter the instance name to indicate the selected workbook

Sheet Name

Indicate the name of the sheet within the Workbook to activate

Range

Indicate the range to insert (ex. A1 or A1:C1)

Shift Direction

Choose how the cells below shift after insert

  • Down: insert value and shift cells down

  • Right: insert value and shift cells right

  • Entire row: insert value entire row

  • Entire column: insert value entire column

Returned Value

This command does not have returned value.

Example Usage

Example Location:

BYpass\Examples\Excel Commands\Insert Cell\Insert Cell.xml

See Also