blanc line

[leovh]

Hello



I have a sorted alphanumeric array with names and want to introduce a
blanc line each time that the name changes. Merci for help.

 

[Don Guillett]

try this idea

Sub insertrowsif()
mc = 1 '"a"
For i = Cells(Rows.Count, mc).End(xlUp).Row To 2 Step -1
If Cells(i, mc) <> Cells(i - 1, mc) Then Rows(i + 1).Insert
Next
End Sub