ActiveCell.Offset(1, 0).Range("A1").Select?

[prabhafriend]

I know ActiveCell.Offset(1, 0) but ActiveCell.Offset(1, 0).Range("A1")?

What the exact use of mentioning ranges after an offset?

Please Explain

[Bob Phillips]

It can further qualify the object being referenced. For instance


ActiveCell.Offset(1,0).Value

and


ActiveCell.Range("A2").Value

are equivalent.

In this case, it adds nothing as it is saying the first row and first column selected, which is the same in a 1-cell selection.