Break line

[mikesal57]

Hey Guys...

How can I add a break line between when a new set of numbers appear...

[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Date[/TD]
[TD="class: xl63, width: 64"]Post[/TD]
[TD="class: xl63, width: 64"]Track[/TD]
[TD="class: xl63, width: 64"]Racenum[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:00[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:00[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:00[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:00[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:00[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:00[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:29[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:29[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:29[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:29[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:29[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:29[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]2[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]16:57[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]3[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]17:24[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]4[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]17:24[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]4[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]17:24[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]4[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]17:24[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]4[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]17:24[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]4[/TD]
[/TR]
[TR]
[TD="class: xl63"] 3/20/19[/TD]
[TD="class: xl64"]17:24[/TD]
[TD="class: xl63"]CT[/TD]
[TD="class: xl63"]4[/TD]
[/TR]
</tbody>[/TABLE]

I need to add a blank row everytime column 4 changes..

Thxs

Mike

 

[Fluff]

How about

Sub mikesal57()
   Dim i As Long
   
   For i = Range("D" & Rows.Count).End(xlUp).Row To 3 Step -1
      If Range("D" & i) <> Range("D" & i - 1) Then Rows(i).Insert
   Next i
End Sub

 

[mikesal57]

Thanks Fluff

 

[Fluff]

You're welcome