Documentazione HotXLS
Home Contenuti Panoramica

Insert metodo

Inserts a cell o a range of cells into the Worksheet e shifts other cells away to make space

Sintassi

funzione Insert(Shift: OleVariant): OleVariant;
Shift OleVariant. Specifica which way to shift the cells. Can be one of the following XlInsertShiftDirection constants: xlShiftToRight o xlShiftDown

Esempio

This example inserts a new row before row 3 

Workbook.Sheets[1].Range['A3', 'A3'].EntireRow.Insert(xlShiftDown);