View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
 
Posts: 290
Default Finding a cell, selecting the one down

You can use activecell.offset(1,0) to move one cell down, from the line
you already have just put .offset(1,0) and that should do it. I try to
avoid using cell.offset as it is dependant on being in the right place
always!


(when using the offset, the 1,0 is easy to remember by -1,0 being
upwards and 1,0 being downwards, the number after the comma is left or
right, plus or minus)


HTH

Duncan