Hi
I have a spreadsheet that has a different number of records every day. As part of a procedure, I need to insert a new line (starting at row 2) so that between every record there is a blank row.
How do I do this please?
BD
Hi
I have a spreadsheet that has a different number of records every day. As part of a procedure, I need to insert a new line (starting at row 2) so that between every record there is a blank row.
How do I do this please?
BD
Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
Untested
[vba]
With Activesheet
lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = lastrow To 1 Step -1
.rows(i+1).insert
Next i
End With[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber