John

How about a macro to go to bottom of selected column(s)?

Sub GODOWN()
Dim maxrow As Long
With ActiveCell.Parent.UsedRange
maxrow = .Cells(.Cells.Count).Row + 1
End With
ActiveCell.Parent.Cells(maxrow, ActiveCell.Column).End(xlUp).Select
End Sub


Gord Dibben Excel MVP

On Thu, 23 Jun 2005 09:23:08 -0700, "John Boyee" <John
Boyee@discussions.microsoft.com> wrote:

>Does anyone know a way to set a tab or something to stop at the bottom or
>right of a table when the data ends? If i try to scroll down while selecting
>data it speeds up so fast it jumps past were I want to stop. Are there any
>settings to stop this issue?