Step 5: Now let us use the select statement to select the range in the variable. Step 4: Now use the set statement to assign a range value to our variable with the help of the range property method. Step 3: Since we are going to execute the procedure in sheet 3 let us activate Sheet 3 first. Step 2: Now declare a variable as Range data type to store the values of a range. Step 1: The defining of the subprocedure will be same as for all the codes above, let us begin right below the example 3 in the same module as shown below. In this example, we will use a variable as a range to select a few cells from a sheet 3.

Step 7: Now once we execute the above code we get the following result. Step 6: Now in order to display the value which has been stored in our variable let us use the msgbox function as follows in the image below. Step 5: We can see that there is data in cell A1 so we will use the Set statement to assign the value of cell A1 to our variable using the range property method. Step 4: Before we begin to our next code let us first see what is in the value of cell A1 in sheet 2. Step 3: Now we have discussed earlier the importance of activating a worksheet before using it for our example so we need to activate the Sheet 2. Step 2: Let us set a variable as a Range data type so that it can hold or store a range of values. Below the first code initiate another subprocedure. Step 1: We will begin our next example in the same module we have inserted so we do not need to insert a new module for every procedure. In this example, we will discuss how to use the range variable to fetch data from a cell and display it on the screen. Now let us use Range as a variable in VBA, we can use range as variable and set the variable with the values using the range property method. We can see that in our code we chose the cells from A1:C3 to have these custom values, this example was the basic representation of what we can do with the range property method. Step 5: Run the code by pressing the F5 key or by clicking on the Play Button. Once we execute the code we can see the value in Sheet 1 as follows. Step 4: Now let us begin the simple operation by assigning a custom value to the cell of the worksheet 1 using the range property method.

Excel for mac vba to clear a range