moving the cursor in a macro

  • Thread starter Thread starter Amanda
  • Start date Start date
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
 
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

Similar Threads

moving cursor in a macro 3
Help with a Macro 1
The Relative Macro 6
Moving Cursor after Cell Entry 1
vba macro that allows insertion of symbols at cursor 0
Bold rectangle cursor in VB Editor 3
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

Back
Top