Results 1 to 19 of 19

Scrolling left or right depending on position within active sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Scrolling left or right depending on position within active sheet

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Retrieving the sheet name to the left of the active sheet
    By JPaniagua in forum Excel General
    Replies: 2
    Last Post: 03-10-2014, 12:42 PM
  2. Active cell moving but sheet is not scrolling
    By AmStaffMom in forum Excel General
    Replies: 3
    Last Post: 05-30-2012, 02:08 PM
  3. relative position of active cell over multiple sheet
    By endoskeleton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2011, 09:28 AM
  4. How do I know which sheets are to the RIGHT and LEFT to the Active Sheet?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-04-2011, 11:07 AM
  5. using a value from the sheet to the left of the active sheet
    By vn900 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2011, 05:24 AM
  6. Position cell in top left position
    By Hein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2009, 05:48 AM
  7. keep active sheet view and cursor position
    By killa47 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-08-2005, 05:20 AM
  8. [SOLVED] Freezes chart position with scrolling
    By PauloEd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1