In this example we will see, how to Autofill numbers. ![]() And we will see, in a moment list of months from Jan to Dec will get automatically filled from cell A3 to A12. Step 7: Once done, compile the code and run it by clicking on the Play button which is located below the menu bar in VBA or Press F5. Range("A1:A2").AutoFill Destination:=Range("A1:A12"), Type:=xlFillMonths Select the Type as xlFillMonths as shown below. Step 6: Now here comes the moment, when we will select the time of autofill we need. We can select any range but selecting the same range makes it easy to implement. Step 5: Now select the range where we will need to autofill the names of months till Dec. Step 4: Now select the function we need to perform which is “ Autofill”, allowing the Destination to get selected as shown below. Step 3: Select the range of the cells which we need to drag or extent for autofill.
0 Comments
Leave a Reply. |