I run a macro to look for a value in a cell. When it is found I exit the
routine and select the entire row of the active cell for the user to see.
However, sometimes the row itself is beyond the view of the user (i.e. Row
100). Upon selecting the entire row, how do I change the screen view (scroll
down) so that that row is visible to the user? That is selecting it is
useless if the view cannot even see it.

Thanks