While you've almost certainly discovered the difference between this selection and solution #one is that, now, Excel notifies you that a macro is disabled. This is the default solution in Excel and, as discussed in Excel 2013 VBA and Macros When you halt dragging, the selected region seems on the https://www.customguide.com/excel/excel-left-function