Step 6: Let us end the Statements using the End statement as shown below.

Step 5: Now again we use the dot (.) operator in the code to change the font to Bold and Italic. Step 4: Access the Font property of the Rng variable using the with statement. Step 3: Now declare a variable as Range data type which will store the range for our data as shown below and set the range to the range which has our data in sheet 3. Step 2: Also we have now more than one sheet in this workbook so let us activate sheet 3 with the following code. First, let us look at the data in sheet 3 as follows. For this, follow the steps below: We want to change the font to Bold and Italic using the With statement. For this example, we have similar text in cells B2 to D5 and they are in normal fonts. In this very basic example, we will see another font feature to manipulate using the With statement. Step 7: When we execute the code we get the following result in sheet 2. Step 6: Now let us end the with statement with the END WITH statement as follows. Step 5: Now we can use the dot (.) operator to change the color of the range using the following code and change the color of the text in the cell range. Step 4: Access the Font property of the Rng variable using the with statement with the following code shown below. Step 3: Now declare a variable as Range data type which will store the range for our data as shown below and set the range to the range which has our data in sheet 2. Step 2: Also we have now more than one sheet in this workbook so let us activate sheet 2 with the following code. Step 1: Now in the same module declare another subprocedure as follows. First, let us see the current data in sheet 2 as follows. For this, follow the steps below: I have some data in Sheet 2 in the cells A1 to C3 in normal black color and I want to change the text font to blue using With Statement. In this example, we will see how to change one of the fonts or the color of the property of the object. Step 6: Now, run this code by hitting the Run button or F5. Step 5: Always remember to close the with statement with an End statement. Step 4: When we type a dot (.) we can see a range of different functions associated with the object.

Excel vba range with variable name