moving around cell

[Bre-x]

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

activecell.moveleft 1

or something like that

Thnks

 

[Peo Sjoblom]

Look at offset


--


Regards,

Peo Sjoblom

 

[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