blanc line

  • Thread starter Thread starter leovh
  • Start date Start date
L

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top