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: Array Functions – LBound and UBound()
2. VBA Excel – Looping Through a Range of Cells
3. Excel-VBA : Change Passwords for all the WorkSheets in one shot
4. VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation
5. VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers