VBA Formatting Text
VBA Color Selected
VBA Metric Converter
VBA Do Loop Sum
VBA Sum of Powers
VBA Sort Array
VBA Simple Loop
VBA Harmonic Mean
VBA Alternate Color
VBA Even or Odd
VBA First Capital Letter
VBA Intersection
VBA Ascending Order
VBA Concatenate
VBA Select Case
VBA Columns to Lines
VBA Making an Addition
VBA Offset Resize
VBA Search and Color
VBA Current Region
VBA Simple Email

VBA Message Box
VBA Final Score
VBA Factorial Function
VBA Infinite Series
VBA Count dollar bills
VBA Prime Number
VBA If Insert Cell
VBA Text to Columns
VBA Even and Odd
VBA Ballot Box

Basic Exercise

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):

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

- 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)`

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

Show Answer

VBA Formatting Text
VBA Color Selected
VBA Metric Converter
VBA Do Loop Sum
VBA Sum of Powers
VBA Sort Array
VBA Simple Loop
VBA Harmonic Mean
VBA Alternate Color
VBA Even or Odd
VBA First Capital Letter
VBA Intersection
VBA Ascending Order
VBA Concatenate
VBA Select Case
VBA Columns to Lines
VBA Making an Addition
VBA Offset Resize
VBA Search and Color
VBA Current Region
VBA Simple Email

VBA Message Box
VBA Final Score
VBA Factorial Function
VBA Infinite Series
VBA Count dollar bills
VBA Prime Number
VBA If Insert Cell
VBA Text to Columns
VBA Even and Odd
VBA Ballot Box

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.

© 2019 SuperExcelVBA | ABOUT

Thank you for contributing. A message was sent reporting your comment.