Microsoft KB Archive/65332

{|
 * width="100%"|

Macro to Set the Last Cell in Selected Range as Active Cell

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0

-

SUMMARY
After a range of cells is selected on a Microsoft Excel worksheet, the active cell is the first cell in the range. The macro command to make the last cell in the range the active cell is as follows:

  =SELECT(,&quot;r[&quot;&ROWS(SELECTION)-1&&quot;]c[&quot;&COLUMNS(SELECTION)-1&&quot;]&quot;)

If the range A1:D5 is the current selection, D5 will become the active cell after executing the above command.

Note: the information above also applies to version 5.0 only when using version 4.0 macro language.

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.0

Keywords :

Version :

Platform :

Issue type :

Technology :