Clicking And dragging your mouse throughout 1000s of rows is equally slow and susceptible to error. A considerably quicker way to choose a big, steady block of data is with keyboard shortcuts. Thanks for sharing trouble. I've modified your code and am sharing the workbook with you in the attachment. https://main.shuwb.com/bbs/board.php?bo_table=free&wr_id=40760