Active Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Excel 2000

What is the macro command to move the active cell up and down a row without
giving specific cell references in the same manner you can move columns right
and left with "ActiveCell.Next.Select" and "ActiveCell.Previous.Select"
respectively.
 
Using the Offset property:

ActiveCell.Offset(1).Select

to move one row down

ActiveCell.Offset(-1).Select

to move one row up
 
Hi
activecell.offset(1,0).select
and
activecell.offset(-1,0).select
 
You must log in or register to reply here.

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

MACRO - go UP or DOWN 2
VBA set thick borders around non empty cells in range 0
Find and move cells with text 8
macro recording 3
Select first cell in active row? 1
Moving an active cell 4
move one cell down 5
Search for empty cells and move cells next to 10

Back
Top