:-Īnswer = InputBox('How many lines to insert? (20 lines maximum)"įor Each ws In ThisWorkbook.Worksheets ws. Unselect the columns to see if the problem is fixed. First of all select multiple rows in your spreadsheet, by multiple I mean they should be equal to the number of rows that you want to insert. You can select multiple rows by pressing Ctrl and clicking on the row.
Answer = InputBox('How many lines to insert? (20 lines maximum)')Ī(Int(InputBox('How many lines to insert?'))).Insertīoth of the above work but only on the active sheet I have tried the routine below to insert the rows on all work sheets but I am getting this compile/syntax errorįor Each ws In ThisWorkbook.Worksheets ws.Activate You cant use the Insert Row option if one or more columns are selected. Highlight the entire row by selecting the row number on the left side of the screen.
0 kommentar(er)
