We have already gone over what variables and constants are, in our VBA Data Types – Variables and Constants tutorial. We are now going to look at the range object in VBA and how to declare a variable as a range object. The range object is used to denote cells or multiple cells in VBA. So, it’s very useful to use in your code.

The VBA Range Object

You can use the range object to refer to a single cell. For example, if you wanted to refer to cell A1 in your VBA code then you could use the VBA range object as shown in the code below:

When you press run or F5 on your keyboard, to run your code then you get the following result, in your actual worksheet:

You can use the range object to refer to multiple cells or ranges. For example, if you wanted to refer to cell range (A1:C1) in your VBA code then you could use the VBA range object as shown in the code below:

When you press run or F5 on your keyboard, to run your code then you get the following result, in your actual worksheet:

Declaring a Variable as a Range

You will need to use the Dim and Set keywords when declaring a variable as a range. The code below shows you how to declare a variable as a range.

The result is:

Selecting Specific Rows In Your Range Object

You can select specific rows within your Range Object. The code below shows you how to do this:

The result is:

 

Selecting Specific Columns In Your Range Object

You can select specific columns within your Range Object. The code below shows you how to do this: