Click Insert > Module, and paste the following code in the Module Window. Specify a row which you want to copy and insert multiple times, and then hold down the ALT + F11 keys, then it opens the Microsoft Visual Basic for Applications window.Ģ. If you want to duplicate only one specific row x times, the following VBA code may help you, please do as this:ġ. Copy and insert each row multiple times based on a specific number with an awesome featureĬopy and insert a specific row multiple times with VBA code.Copy and insert each row multiple times with VBA code.Copy and insert a specific row multiple times with VBA code.How could you deal with this job in Excel?
In your daily work, have you ever tried to copy a row or each row and then insert multiple times below the current data row in a worksheet? For example, I have a range of cells, now, I want to copy each row and paste them 3 times to the next row as following screenshot shown. How to copy and insert row multiple times or duplicate the row x times in Excel?
0 kommentar(er)
