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
To go to Top of list try Ctrl+HOME.
Try this code to go to Bottom of your list.
Hope this helps.
Please Login or Register to view this content.
Regards,
Kumarapush123
OfficeTricks.com - Excel VBA Macro - Tips and Tricks
Hi, labogola,
maybe use
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
HaHobe. I just noticed something with your code. Going up to the top works fine, but scrolling down depends on the user clicking on the first column. Otherwise it doesn't work.
Hi, laboga,
not with the sniplets I posted - itīs always the highlighted cellīs column where the jump will be taken (no merged cells when I tested which may be the reason for a different result).
Ciao,
Holher
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks