Macro to add row between list of data...

[Guest]

Can anyone provide me with a macro that will add a row between a lost of
data?? I've recorded on that will add a row but don't know how to extend it
through the entire list of data...if I insert 2 rows and stop recording, it
only adds two rows. I would like it to insert a row between the full list of
data or selected list.
Many thanks for any help given.

 

[Don Guillett]

Sub insertrows()
For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1
Rows(i).Insert
Next
End Sub

 

[Guest]

Another dumb question: Can you tell me how to use this...how to set it up as
a macro and run it (and I'll be out of your hair!!)
Many thanks....

 

[Guest]

Don,
I've done it!!! Thank you so much. It did exactly what I wanted it to do.

Is there a tutorial or instructions for macros online anyplace? I'd like to
learn how to create them.

Thanks so much for your help.

 

[Gord Dibben]

David McRitchie's site for getting started.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Tushar Mehta's section on "beyond the macro recorder" has some good pointers on
cleaning up the code that was created by the recorder.

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm


Gord Dibben MS Excel MVP

 

[Guest]

Looks like a good starting point for me. Thanks so much.