RemoveAt Method (WorksheetCollection)

Removes the sheet at the specified index.

Syntax

'Declaration
 
Public Overrides Sub RemoveAt( _
   ByVal index As System.Integer _
)

'Usage
 
Dim instance As WorksheetCollection
Dim index As System.Integer
 
instance.RemoveAt(index)

public override void RemoveAt( 
   System.int index
)

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	index is not a valid index in the collection.
System.NotSupportedException	The collection is read-only.

Example

This example uses the RemoveAt method.

//Remove some sheets
gcSpreadSheet1.SheetCount = 5;
gcSpreadSheet1.Sheets.Remove(gcSpreadSheet1.Sheets[1]);
gcSpreadSheet1.Sheets.RemoveAt(0);

'Remove some sheets
GcSpreadSheet1.SheetCount = 5
GcSpreadSheet1.Sheets.Remove(GcSpreadSheet1.Sheets(1))
GcSpreadSheet1.Sheets.RemoveAt(0)