Go to the Ribbon > Insert > Add-Ins Group > Get Add-Ins. Method 2: Download add-ins from inside Microsoft PowerPoint. Click the add-in button and a sidebar appears on the side of your document. Using the above method, you can add or insert multiple rows with the click of a button. The add-in will appear on the extreme right of the Ribbon. Next, I’ll get the row number of the selected row and insert a new row using the EntireRow.Insert property.įinally, I am updating the Codes (the number series) of the remaining rows, in the first column. The variable iTopRow has a value 1, so the macro won’t insert rows before the first row in your worksheet. The button’s click event calls a procedure named addNewRow().
The code will automatically insert a new row before the selected row (the row you’ve set focus on) or the cell you’ve set focus. Simply set focus on a cell and click the button. You can select the entire row and then click the button.
To check if the code is working, set focus on a cell where you want to insert a new row, anywhere in your Excel worksheet and click the command button.
