Offset Resize

Basic Exercise

Statement

From cell "B3", using the Offset and Resize properties, paint green the inner range determined by "C7: G17" (delimited by the edges of the borders as shown below):

Suggested Concepts:

Offset - Shifts the position of the range.
Resize - Resize the selection.

Remember that in most cases there is more than one way to solve the exercise.

Hint: It is possible to change those properties in the same line of code.

Solved Exercise

Exercise Solution

From the range "B3" use the Offset property to move the reference to "C7" (four lines down and one column to the right). Afterwards use the Resize property to define the hole area.
```
Range("B3").Offset(4, 1).Resize(11, 5).Interior.Color = RGB(140, 198, 63)
```

Consolidated Answer

    Sub Solution()

    Range("B3").Offset(4, 1).Resize(11, 5).Interior.Color = RGB(140, 198, 63)

    End Sub

Show Answer

Download exercise Download answer

SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

INTRODUCTION

BASIC

INTERMEDIATE

ADVANCED