Actually, toward the end of that same line, I think it should be:
Looks like this code should run when you select two cells in row 31. It is then copying the cells one column over and 23 through 31 rows down, pasting it to the first open column in Sheet 2 row 1, and deleting what was copied on the original sheet. Is that what you intended? It may help to step through the code using F8. You can place a bookmark on any line of the code by clicking the left margin next to that line of code. A brown dot will appear and the line will be highlighted brown. Then the code will run until it gets to the bookmark, and it will stop. Then you can step through each line using F8.
Bookmarks