Microsoft KB Archive/26886

{|
 * width="100%"|

Excel: Selecting Active Portion of Spreadsheet Using a Macro

 * }

SUMMARY
To select the entire active portion of a Microsoft Excel worksheet using a macro, do the following:


 * 1) Select the range from the first cell in the upper-left corner of the worksheet through the last active cell.
 * 2) Use the following commands in a command macro:

=SELECT.LAST.CELL

=SELECT(ACTIVE.CELL:!A1)

For more information about the SELECT.LAST.CELL function, see page 382 in &quot;Microsoft Excel Function Reference,&quot; version 4.0 manual. If you are using version 3.0, see page 213 in the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual. If you are using Excel 2.20, see page 277 in the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :