ActiveSheet Property (Workbook)

Gets or sets the active sheet in the component.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property ActiveSheet As Worksheet

'Usage
 
Dim instance As Workbook
Dim value As Worksheet
 
instance.ActiveSheet = value
 
value = instance.ActiveSheet

[System.ComponentModel.DefaultValue()]
public Worksheet ActiveSheet {get; set;}

Property Value

The active sheet in the workbook.

Exceptions

Exception	Description
System.ArgumentException	The specified sheet is not in the collection.

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Workbook Class
Workbook Members