I am attempting a simple macro in Excel 2007. I have a long list of descriptions in say column B. I need to add a space at the end of each description. My active cell is B2.
1. I turn on "Record Macro"
2. I press F2 to edit the cell.
3. I press the space bar.
4. I press the Enter Key to accept my space. The cursor goes down to B3.(set to go Down in Excel Options)
5. I click "Stop Recording".
When I press the assigned Ctrl-key the macro puts the space in the field just fine. But it always returns to cell B3 instead of the cell immediately below. How do I make so it goes down one cell instead of always returning to B3? Thank you!