I've got a big sheet with random gaps in the data entries, so that when I use ctrl up or down it won't actually scroll the bottom of the sheets range and it'll get stuck in random places. I need the gaps to stay. Is there some VBA code I can use in the quick bar to instantly scroll to the top or bottom of the sheet?

I've attached and example. It's even worse in excel 2007, sometimes CTRL UP just gets caught on the frozen top row.

quickscroll.xlsx