Macro needed (Number Spacing)

[ironsides]

starts cell C19
Cells in col C contains numbers
I want to insert a blank line when the number changes in Col C

23
23
23
23
24
24
24
25
26

to look like this
23
23
23
23

24
24
24

25

26

 

[Rick Rothstein]

Give this macro a try...

[table="width: 500"]
[tr]
	[td]Sub InsertRowOnNumberChange()
  Dim R As Long
  For R = Cells(Rows.Count, "C").End(xlUp).Row To 20 Step -1
    If Cells(R, "C").Value <> Cells(R - 1, "C").Value Then Rows(R).Insert
  Next
End Sub[/td]
[/tr]
[/table]

 

[ironsides]

Thank you Rick Did the trick quickly Ironsides