moving the cursor in a macro



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.




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