moving around cell
 

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

activecell.moveleft 1

or something like that

Thnks

Look at offset


--


Regards,

Peo Sjoblom


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

activecell.moveleft 1

or something like that

Thnks

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