VBA Excel - Cells, Ranges and Offset : Offset

Offset:

• Offset property in VBA-Excel is used along with Range.
• With the help of Offset property user can move around in the sheet.

Format:

Range(“StartingPoint”).Offset(NoOfRowsToBeMoved , NoOfColumnsToBeMoved)

Example :

Range(“A2”).Offset(1,0).Select

And compiler reads, move one cell down from A2 , which is A3.

Range(“A2”).Offset(-1,0).Select

And compiler reads, move one cell Up from A2 , which is A1.

Range(“A2”).Offset(1,1).Select

And compiler reads, move one cell down and one cell right from A2 , which is B3.

ActiveCell.Offset(1,1)

And compiler reads, move one cell down and one cell right from the selected cell.

Also Read:

1. VBA-Excel: String Functions – Replace()
2. VBA Excel – Looping Through a Range of Cells
3. VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()
4. VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order
5. VBA-Excel: Consolidator – Merge or Combine Multiple Excel Files Into One