moving cursor in a macro
 

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

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

moving cursor in a macro
 

Perfect! Worked like a charm! you are a life saver!!

"JLatham" wrote:

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

moving cursor in a macro
 

ActiveCell.Offset (-1,0).Select

Aqib Rizvi