moving cursor in a macro
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.
"Amanda" wrote:
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
|