Step 2: Open With-End With loop choosing the current worksheet as Sheet1. Step 1: Open a module and directly write the subprocedure for VBA Set Range. In this example, we will see how to set Range in different cell range and choosing the different text into the 2 or more different cell Range. There is another way to apply VBA Set Range. We will see the chosen cell range A1: B5 has now text as TEST as shown below. Step 6: Once done, run the code after compiling. Step 5: Let’s consider a text which we want to insert in the selected range cells as TEST as shown below.
Step 4: Further setting up the range object with declared variable MyRange, we will then choose the cell which wants to include. Step 3: Declare the variable using DIM as Range object as shown below.
0 kommentar(er)
