Move to a specific cell and make it the top
Posted on 2014-01-18
In my spreadsheet I have command buttons that takes the user to specific cell location. For example, cmdTextFomatting_Click executes Range("A47").Select. No problem here. However, the user has asked that when they go to a specific cell location that it also makes that cell location the top of the spreadsheet just as if the user scrolled.
Each section also has a command button labeled "Top" and this goes to cell A1 that returns them to the top. This is FYI so you can understand how they would return to the top.
I thought of hiding the columns not needed and unhiding them when they returned to the top, but wanted to know if there was an better way?