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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving the cursor in a macro 1
The Relative Macro 6
Moving Cursor after Cell Entry 1
Help with a Macro 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Is there a way to make the enter button work as regular enter in c 3
Macro Code 2

Back
Top