Total Pageviews

Saturday, October 27, 2018

How to Select a Specified Range, Offset It, and Then Resize It






















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: