View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TKT-Tang TKT-Tang is offline
external usenet poster
 
Posts: 14
Default Re : MS Excel’s Offset Property

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.