moving cursor in a macro

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

How do I have the macro move the cursor up one row from any cell.
ie: If cursor was on A13 before I run the macro and I want it to move A12
or if cursor was on B23 before I run the macro and I want it to move to B22

p.s. I've tried using the up arrow as well as Shift Enter and neither work

Amanda
 
The macro should have recorded the move if it was made while recording the
macro. But none the less, it looks like you want it to move up 1 row,
remaining in the same column.
Add this line of code just before the End Sub statement

ActiveCell.Offset(-1,0).Activate

should do it.
 
Back
Top