Is there a way to suspend an Excel macro until you press Enter?
I’m attempting to create a macro that copies numerous cells up one row. I have the routine working fine except it always defaults to the same starting position/copy to position. However, the original location to begin the routine changes. I believe I need the macro to pause while I place the cursor in the correct location to begin the routine. Any suggestions would be appreciated.
Here is the code that works except it always starts at cell L16 and always copies to cell L15.
1. I want to be able to place the cursor on the correct starting cell in column “L”
2. Copy all cells from the starting cell to the right two columns
3. Paste all cells up one row
In other words I want to remove the data in the three cells starting where I place the cursor
Thanks,
Steve K.
Bookmarks