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: Copy/Paste data - Copy the Entire data from one sheet to another
2. Excel-VBA : Change Passwords for all the WorkSheets in one shot
3. VBA-Excel : Strings Functions – Ucase
4. VBA-Excel: Array Functions – LBound and UBound()