PDA

View Full Version : ActiveCell.Offset(1, 0).Range("A1").Select?



prabhafriend
07-24-2014, 03:04 AM
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
07-24-2014, 03:47 AM
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.