Reply to thread

Message: [QUOTE="DanP, post: 13054266"] I know how to create a relative macro...to a point. I know that when I start recording the macro, I have to pick the RELATIVE button in the little toolbar. I will tell you what I want to accomplish and then what happens. 1. I have a cell (A1) that has a city, state, & zip code (Pittsburgh, PA 15212). 2. Cell B1 is empty and already formatted for text. 3. I place the cursor in cell A1 and start to record the macro. 4. I press the relative button. 5. I double click in A1, hold the shift key down and use the arrow keys to highlight the zip code and the space in front of it. (6 arrow keystrokes to the left) 6. When highlighted, I press Ctrl-X to cut the space and zip code and copy it to the clipboard. 7. I hit <Enter> and the cursor moves down to the next cell. (A2) 8. I use the arrow keys to move the cursor back up and to the right cell (B1). 9. I press Ctrl-V to paste the zip code into B1 and hit <Enter> which moves the cursor down to B2. 10. I use the arrow keys to move the cursor over to cell A2. 11. I then stop recording the macro. You can see that I want to strip the zip codes out of one cell and put it into another. Here's is what happens. The macro runs great as far as the movement and the cutting of the zip codes. But, when it moves to the next cell, it always pastes the same number...the one that was originally cut and copied in the original cell. What am I doing wrong? Does it have something to do with the relative vs actual? Please help, [/QUOTE]

Verification