View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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/