Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Example:
My sheet needs to insert a blank row under a number everytime it changes. The column "C" may have 20 or so rows with the number 10 for example, the next five might be the number 8, I need a row between the last number ten and the first number eight. This may be repeated many times through the spreadsheet. As well, the adjacent columns "D" & "E" are the same as described above. all 3 columns are continuous ie: C D E 8 8 8 8 20 20 20 20 10 10 10 5 5 9 9 9 12 12 12 therefore I need to insert a row between 8 & 20, 20 & 10, 10 & 5 and etc. I hope that I have articulated this well enough. I've tried the following but it is for only one column and I assume it's the reason I get a sytax error at: cells(nr,1.select sub blnkentery() nr=Application.WorksheetFunction.counta("A:A") for r = nr to 2 step -1 cells(nr,1.select if cells(nr,1) < cells(nr-1,1) then Selection.EntireRow.Insert next r end sub please help Thank You for your time Luke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
insert rows in excel spreadsheet via macro | Excel Worksheet Functions | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
In Excell sheet i want to insert more than 65,536 rows how i can . | Excel Worksheet Functions | |||
Adding Rows to Master Sheet | New Users to Excel |