Hi there I am hoping to get some help translating what I have below into functional code. The goal is to start at B2 and go down the column checking every cell to the next one and if they are different insert cells above between A:E, if they are the same continue moving down. Any imput would be greatly appreciated. Thanks!
![]()
Dim Check_Row As Long Dim Last_Row As Long Check_Row = B2 //Will always be B2 LastRow = Cells(Rows.Count, "B").End(xlUp).Row While Check_Row<Last_Row if Check_Row != (Check_Row+1) Range("A" & Check_Row & ":" & "E" & Check_Row).Select Selection.Insert Shift:=xlDown Check_Row+1 else Check_Row+1
Bookmarks