Search notes:

Excel Object Model: Range.Select

rng.select (visually) selects the specified range and moves (if possible) the range's top left cell to the center of the current window. (Compare with the .scrollRow and .scrollColumn properties of the window object).
Only ranges of the currently active worksheet can be selected (See also Excel 2003 VBA Reference: Selecting and Activating Cells).
If rng.select is invoked while application.screenUpdating is set to false, Excel will select the cell, but not move to it, even after reverting application.screenUpdating to `true.

See also

The Range object.
The .selection property of the application object returns the Range that is currently selected.
The method application.inputBox allows a user to select a range with the mouse and pass the selected range to a VBA program.
The select method of the worksheet object.

Index