HotXLS-documentatie
Startpagina Inhoud Overzicht

Delete-methode

Deletes a cell of a range of cells from the Worksheet

Syntaxis

functie Delete(Shift: OleVariant): OleVariant;
Shift OleVariant. Specificeert how to shift cells to replace deleted cells. Can be one of the following XlDeleteShiftDirection constants: xlShiftToLeft of xlShiftUp

Voorbeeld

This example deletes row 3 from sheet one 

Workbook.Sheets[1].Range['A3', 'A3'].EntireRow.Delete(xlShiftUp);