moving the cursor in a macro

A

Amanda

How do I move up one cell from where the cursor is in a macro (which could be
a random location in a workbook).
I don't want the cursor to be in a fixed location.
For example, if the cursor was in A4 before I run the macro. I want the
macro to move the cursor to A3. If the cursor was in B12 before I run the
macro, I want the cursor to move to B11.

p.s. I've tried using the arrow key as well as Shift Enter neither works.

Amanda
 
J

JE McGimpsey

the macro recorder only records the results of your actions, not the
steps or keypresses.

One way:

Put this in as the first lines of your macro:

With ActiveCell
If .Row = 1 Then Exit Sub
.Offset(-1, 0).Activate
End With
 

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

Top