It's just a waste of cycles - using the Range property of a range
offsets the range by an amount equivalent to the offset of the
reference from A1.
Since I can't even parse that sentence at this hour, here's an
example, assume the Selection is at F8. Then
Selection.Offset(3,1).Select selects G11
Selection.Offset(3, 1).Range("A1").Select also selects G11
Selection.Offset(3, 1).Range("B1").Select selects H11
Selection.Offset(3, 1).Range("A2").Select selects G12
Selection.Offset(3, 1).Range("B2").Select selects H12
In article ,
(TKT-Tang) wrote:
Re : MS Excel’s Offset Property
The following example selects the cell three rows down from and one
column to the right of the cell in the upper-left corner of the
current selection.
Worksheets("sheet1").Activate
Selection.Offset(3, 1).Range("A1").Select
The question is,
what is the significance of dotting with Range("A1") ?
Regards.