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
|