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: Select and Activate Cells - Activate
2. VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook)
3. Getting Started with Excel Macro
4. VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
5. VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers