{"action":"created","issue":{"url":"https://api.github.com/repos/byronwall/bUTL/issues/24","labels_url":"https://api.github.com/repos/byronwall/bUTL/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/byronwall/bUTL/issues/24/comments","events_url":"https://api.github.com/repos/byronwall/bUTL/issues/24/events","html_url":"https://github.com/byronwall/bUTL/issues/24","id":98428791,"number":24,"title":"Improve Selection shifter/offsetter","user":{"login":"byronwall","id":495404,"avatar_url":"https://avatars.githubusercontent.com/u/495404?v=3","gravatar_id":"","url":"https://api.github.com/users/byronwall","html_url":"https://github.com/byronwall","followers_url":"https://api.github.com/users/byronwall/followers","following_url":"https://api.github.com/users/byronwall/following{/other_user}","gists_url":"https://api.github.com/users/byronwall/gists{/gist_id}","starred_url":"https://api.github.com/users/byronwall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/byronwall/subscriptions","organizations_url":"https://api.github.com/users/byronwall/orgs","repos_url":"https://api.github.com/users/byronwall/repos","events_url":"https://api.github.com/users/byronwall/events{/privacy}","received_events_url":"https://api.github.com/users/byronwall/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-07-31T16:49:08Z","updated_at":"2015-07-31T16:57:55Z","closed_at":null,"body":"There is a whole interface on the Ribbon for shifting the `Selection` a given number of rows/columns.  This would probably be much better off with a quick keyboard shortcut that shifts the `Selection`.  The interface as it sits is not that useful.  I have actually never used it.\r\n\r\n![image](https://cloud.githubusercontent.com/assets/495404/9012402/b6a77d12-3771-11e5-998d-81745db099b6.png)\r\n\r\nDecent shortcuts would be CTRL+ALT+{ARROW} to move the `Selection` around.  This has the downside of being the same shortcut used to flip the monitor around.  Not sure if that takes precendence; I disable the monitor flipping stuff.  Another option would be CTRL+ALT+SHIFT+{ARROW} which is not commonly used (I don't think) but involves a lot of keys at once.\r\n\r\nRelevant code:\r\n\r\n```vba\r\nSub SetHotKeys()\r\n    'this would go into an onload for the Ribbon.\r\n\r\n    Application.OnKey \"^%{RIGHT}\", \"OffsetRight\"\r\n\r\nEnd Sub\r\n\r\nSub OffsetRight()\r\n    \r\n    Selection.Offset(, 1).Select\r\n\r\nEnd Sub\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/byronwall/bUTL/issues/comments/126751734","html_url":"https://github.com/byronwall/bUTL/issues/24#issuecomment-126751734","issue_url":"https://api.github.com/repos/byronwall/bUTL/issues/24","id":126751734,"user":{"login":"byronwall","id":495404,"avatar_url":"https://avatars.githubusercontent.com/u/495404?v=3","gravatar_id":"","url":"https://api.github.com/users/byronwall","html_url":"https://github.com/byronwall","followers_url":"https://api.github.com/users/byronwall/followers","following_url":"https://api.github.com/users/byronwall/following{/other_user}","gists_url":"https://api.github.com/users/byronwall/gists{/gist_id}","starred_url":"https://api.github.com/users/byronwall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/byronwall/subscriptions","organizations_url":"https://api.github.com/users/byronwall/orgs","repos_url":"https://api.github.com/users/byronwall/repos","events_url":"https://api.github.com/users/byronwall/events{/privacy}","received_events_url":"https://api.github.com/users/byronwall/received_events","type":"User","site_admin":false},"created_at":"2015-07-31T16:57:55Z","updated_at":"2015-07-31T16:57:55Z","body":"Yea.  It is supposed to just shift the selection.  It was supposed to help in a case where you some funky selection and just wanted to go over one column to delete the cells next door (or something similar).\r\n\r\nAlthough moving the range might be a more useful thing.  Maybe CTRL+ALT moves selection and CTRL+ALT+SHIFT moves the actual contents.  It gets into the same discussion about how to update formulas when doing that, but it might be useful in a number of cases that are not problematic.  Any thoughts on that?\r\n\r\n"}}