Total Pageviews

Showing posts with label and Then Resize It. Show all posts
Showing posts with label and Then Resize It. Show all posts

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