Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
This is my macro to insert lines if the value in b chanbes. I want it to
inset 26 lines it only inserts 1 please help Sub Deilv() Dim LastRow As Long Dim row_index As Long Application.ScreenUpdating = False LastRow = ActiveSheet.Cells(Rows.Count, "b").End(xlUp).Row For row_index = LastRow - 1 To 26 Step -1 If Cells(row_index, "B").Value < _ Cells(row_index + 1, "B").Value Then Cells(row_index + 1, "B").EntireRow.insert _ (x24ShiftDown) End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Line Insert | Excel Discussion (Misc queries) | |||
Help: I need a macro to add words every 3 lines | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
How do I insert the date using a macro | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |