Range Object

A collection of 12 posts

How To Use VBA Dynamic Range In Excel

Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range. Situation: Each time we add a number and we click the command button, we
23 October 2020

How To Use VBA Compare Ranges In Excel

Below we will look at a program in Excel VBA that compares randomly selected ranges and highlights cells that are unique. If you are not familiar with areas yet, we highly recommend you
22 October 2020

How To Use The Offset VBA In Excel

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). Place a command button on
18 October 2020

How To Use Resize Property In Excel VBA

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 Resize property always takes the top left cell
17 October 2020

How To Test A Selection In Excel With VBA

This program in Excel VBA uses the Count property, IsNumeric function, IsEmpty function and Intersect method to test a selection. Situation: Place a command button on your worksheet and add the following code
16 October 2020

Excel VBA - Union And Intersect

The Union method in Excel VBA returns a Range object that represents the union of two or more ranges (borders below for illustration only). Code line: Union(Range("B2:C7&
16 October 2020

How To Set The Background Color(VBA) In Excel

Changing background colors in Excel VBA is easy. Use the Interior property to return an Interior object. Then use the ColorIndex property of the Interior object to set the background color of a
14 October 2020