View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Bre-x" wrote in message
...
hi,
using code how do you move up down, left, right?

activecell.moveleft 1

or something like that

Thnks