/VBA/Excel insert blank row for value change in column

Excel insert blank row for value change in column

Sub InsertRowsAtValueChangeColumnB()
  Dim X As Long, LastRow As Long
  Const DataCol As String = "B"
  Const StartRow = 2
  LastRow = Cells(Rows.Count, DataCol).End(xlUp).Row
  Application.ScreenUpdating = False
  For X = LastRow To StartRow + 1 Step -1
    If Cells(X, DataCol).Value <> Cells(X - 1, DataCol) Then Rows(X).Insert
  Next
  Application.ScreenUpdating = True
End Sub

https://www.youtube.com/watch?time_continue=3&v=qWbaGnZlLn8&feature=emb_logo

Similar codes

0 vote178 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote166 views1 answer
Vba code to open a file with login rights
VBA
0 vote168 views1 answer
Hello world vb.net
VBA
0 vote182 views1 answer
Vbnet line chart showing extra space
VBA
0 vote216 views1 answer
Wpf dark title bar
VBA
0 vote181 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote175 views1 answer
How to carry text to the next line in a label in vb.net
VBA
1 vote168 views1 answer
VBA Loop through recordset
VBA
0 vote224 views1 answer
Find control with name vb
VBA
0 vote168 views1 answer
Vba get text file content
VBA