Relative Referencing Examples

Seite 1

Relative Referencing Examples

Move from Cell A1 to Cell C4 using relative referencing:

ActiveCell.Offset(3,2).Select

Move from Cell F3 to Cell B7 using relative referencing:

ActiveCell.Offset(4,-4).Select

Move from Cell H8 to Cell K2 using relative referencing:

ActiveCell.Offset(-6,3).Select

Move from Cell E6 to Cell D1 using relative referencing:

ActiveCell.Offset(-5,-1).Select