Sunday, May 11, 2014

OFFSET

** Moving positions from the existing cell, if you use activecell concept inorder to move next to activecell a row or a column use activecell.offset(-1,0) --this will move top row and same column.

ActiveCell.offset(1,0) ----this will make you move to next row and same column.

No comments:

Post a Comment