WorksheetBase.Select Method

Article
01/07/2014

Selects the worksheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Sub Select ( _
    replace As Object _
)

public void Select(
    Object replace
)

Parameters

replace
Type: System.Object

true to remove the current selection and select the worksheet instead; false to extend the current selection to include any previously selected objects and the worksheet.

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example uses the Select method to select Sheet1, and then extends the selection to include Sheet2 and Sheet3.

This example is for a document-level customization.

Private Sub SelectWorksheets()
    Globals.Sheet1.Select(True)
    Globals.Sheet2.Select(False)
    Globals.Sheet3.Select(False)
End Sub

private void SelectWorksheets()
{
    Globals.Sheet1.Select(true);
    Globals.Sheet2.Select(false);
    Globals.Sheet3.Select(false);
}

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Share via