But it does resize the selection to exactly one cell. If you didn't have that,
then the new selection would be the same size as the starting selection.



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.

--

Dave Peterson