Inserting A Blank Row At A Column Change UPDATE In Excel 

Holy cow, three days of trying to figure this out. You solved it. Thank you!!

link to code seems broke, copy and paste from your prev video 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

Thanks for the update.

Can you use this on multiple columns?

Thanks for this! And thanks for linking to it in your last video.

Great easy to understand tutorial. Thanks!

Your tutorial is so much helpful than others.

This is great. Thank you for sharing and making an easy to follow video