Hi all,
I'm not sure this is feasible with VBA (hopefully), but I want to "scroll" with the keystroke CTRL + LEFT or RIGHT arrow to a certain position depending on where I am currently on the active sheet.
e.g.
If the scroll position is currently between "Japan Clusters" and "Korea Clusters" the keystroke CTRL + LEFT ARROW should bring me to the "Japan Cluster", meaning the blue column should be the left most visible column. If I press CTRL + RIGHT ARROW it should scroll to the 'Korea Cluster", if I then press CTRL + RIGHT ARROW again, it should move on to the next cluster ("HMT Cluster").
I have attached a sample file to make things more clear. The keystroke CTRL + RIGHT ARROW currently gets you only to the "Japan Cluster" no matter which part of the sheet you're currently looking at!![]()
Bookmarks