Hello Jmp,

ActiveCell.Offset(1, 0l).Select will select the next cell down from th
active cell. Here are some other examples of the Offset property
Movement is relative to the current cell. Rows move up if the Row i
negative and down if positive. Columns move left if the negative an
right if positive. The starting point is (0,0).

Move Down a Row, same Column use:
ActiveCell.Offset(1, 0)

Move Up a Row, same Column:
ActiveCell.Offset(-1, 0)

Move to Next Column, same Row:
ActiveCell.Offset(0, 1)

Move to Previous Coulmn, same Row:
ActiveCell.Offset(0, -1)

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48776