To select a range six rows below and six columns to the right of the named range "Address" and include three rows and three column more than the named range, you can use the following example:
Range("Address").Select
Selection.Offset(6, 6).Resize(Selection.Rows.Count + 3, Selection.Columns.Count + 3).Select
No comments:
Post a Comment