bookmarks in excel

[Rightmer]

I have a table that has about 1000 rows. Is there a book
mark that I can put in the 1000th row, so that I can push
a button and have it scroll to there instantly? Then
another to go back to the top? I hate having to scroll
back and forth all day.
Thanks in advance.

 

[Roger Govier]

Hi

Here is one method I use with Bank Statements, where row 7 is the start of
my data and I want to toggle between here and the next avilable line in the
sheet.
Cell A1 contains the formula
=COUNTA(A7:A5000)+7

I then have the following macro

Sub NextEntry()
' Toggle between First line of data and next available line in sheet
Dim NextCell As String
Dim Prevcell As String
On Error Resume Next
ActiveWorkbook.Sheets("Bank Statement").Select
Application.ScreenUpdating = False
ActiveSheet.ShowAllData
Application.ScreenUpdating = True
Prevcell = "$A$" & Range("A1").Value
If ActiveCell.Address = Prevcell Then
Range("A7").Activate
GoTo endsub
End If

NextCell = "A" & Range("A1").Value
Range(NextCell).Activate
On Error GoTo 0

endsub:

End Sub

You can then either assign this macro to a button on your sheet, which I do,
or allocate a keyboard shortut to it.

Amend to suit your data.