Range: Activate 方法 (Excel)Range.Activate method (Excel)

• 05/10/2019
• • o

激活单个单元格，该单元格必须处于当前选定区域内。Activates a single cell, which must be inside the current selection. 若要选择单元格区域, 请使用**select** 方法。To select a range of cells, use the Select method.

语法Syntax

表达式。激活expression.Activate

expression 一个表示 Range 对象的变量。expression A variable that represents a Range object.

返回值Return value

VariantVariant

示例Example

本示例选定工作表 Sheet1 上的单元格区域 A1:C3，并激活单元格 B2。This example selects cells A1:C3 on Sheet1 and then makes cell B2 the active cell.

Worksheets("Sheet1").Activate 
Range("A1:C3").Select 
Range("B2").Activate

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈？Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈，获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.