Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain how to setup a shortcut to select the range adjacent to the current selected range. This moves the selection left, right, up, or down and helps with selecting rows or columns that contain blanks. Get the VBA macro code here: https://www.excelcampus.com/keyboard-shortcuts/move-selected-range/

This techniques uses a simple set of macros to move the selection. We can assign the macros to keyboard shortcuts or custom macro buttons on the ribbon.

Here are the other videos and resources mentioned in the video:

Get the VBA macro code here: https://www.excelcampus.com/keyboard-shortcuts/move-selected-range/

New video on how to add the macros to your Personal Macro Workbook: https://youtu.be/EllCPqxdrrc

2 Keyboard Shortcuts to Select a Column with Blank Cells in Excel: https://youtu.be/b8By_uVpBw8

4 Part Video Series on The Personal Macro Workbook:
https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

How to Add Macro Buttons to the Ribbon or Quick Access Toolbar: https://youtu.be/dmdolFcS-fI

How to Run Event Macros Based on User Actions: https://youtu.be/VJWBOuNXHB4
00:00 Introduction
00:45 Keyboard Shortcuts
02:10 Visual Basic Editor
02:56 Moving Selection
04:24 Different Directions
05:13 Keyboard Shortcut
07:08 Workbook Open Event