Skip to main content

ExcelDeleteSheet

Structure

ExcelDeleteSheet(iSheet)

Type

Procedure

Description

This function deletes the indicated sheet.

Parameters

iSheet = the index of the sheet to delete.

Example

Try
ExcelNewFile(3,"v2003")
ShowMessage(ExcelGetSheetCount) 'shows 3
ExcelDeleteSheet(1)
ShowMessage(ExcelGetSheetCount) 'shows 2
Except
ShowMessage(LastExceptionMessage)
End Try