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). 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. Range
object. application.inputBox
allows a user to select a range with the mouse and pass the selected range to a VBA program.