moving cursor in a macro


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
 
Ad

Advertisements

J

JLatham

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.
 
Ad

Advertisements


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
Help with a Macro 1
Moving Cursor after Cell Entry 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel 2007 - Arrow keys backwards in one text box 1
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Cursor Movement with Arrow Keys 1

Top