activecell offset
 

how do i shift the active cell, two cells to the left.

i know that activecell.offset(0,1) will shift it one cell to the
right.

how to do for right??


---
Message posted from http://www.ExcelForum.com/

activecell offset
 

Beware when you are close to column 1 (Column A)
Activecell.offset(0,-2)


"rvik" wrote in message
...
how do i shift the active cell, two cells to the left.

i know that activecell.offset(0,1) will shift it one cell to the
right.

how to do for right??


---
Message posted from http://www.ExcelForum.com/