/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 vote171 views1 answer
Hello world vb.net
VBA
12 votes224 views1 answer
Excel vba write string to text file
VBA
0 vote176 views1 answer
Excel vba copy range with filter
VBA
0 vote158 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote184 views1 answer
Vb run command
VBA
0 vote166 views1 answer
Vba loop through textboxes
VBA
0 vote173 views1 answer
Vba min
VBA
0 vote177 views1 answer
Excel filter by date not working vba
VBA
0 vote175 views1 answer
Vba full date format
VBA
1 vote182 views1 answer
Excel how to format bytes as KB, MB, GB
VBA