View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default MS Excel’s Offset Property

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.