This Command instantaneously selects each cell from your start line all the way down to the last non-vacant cell in that column. You need to use the same logic with other arrow keys: Thanks for sharing problem. I've modified your code and am sharing the workbook along with you inside https://mahavet.org/2026/01/5-simple-techniques-for-mass-copy-file-names-into-excel/