Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.

This example illustrates the CurrentRegion property in Excel VBA.

Below we will look at a program in Excel VBA that compares randomly selected ranges and highlights cells that are unique.

This example teaches you how to select entire rows and columns in Excel VBA.

This example illustrates the End property of the Range object in Excel VBA.

The Font property of the Range object in Excel VBA gives access to a lot of other properties.

Below we will look at a program in Excel VBA that shows a print preview of all the possible football matches from a list of teams.

The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range (border below for illustration only).

The Resize property in Excel VBA makes a range (border below for illustration only) a specific number of rows and columns larger or smaller.

The Union method in Excel VBA returns a Range object that represents the union of two or more ranges (borders below for illustration only).

This program in Excel VBA uses the Count property, IsNumeric function, IsEmpty function and Intersect method to test a selection.

Changing background colors in Excel VBA is easy. Use the Interior property to return an Interior object.