moving around cell

B

Bre-x

hi,
using code how do you move up down, left, right?

activecell.moveleft 1

or something like that

Thnks
 
E

Earl Kiosterud

Bre-x

ActiveCell.Offset(0,-1).Select will move left one cell

ActiveCell.Offset(2, 1).Select move down two, right one
ActiveCell.Cells(3, 2).Select move down two, right one
ActiveCell.Range("B3").Select move down two, right one
 
Top