Insert 2 rows between every line of data (Excel 2010)

[Louise H]

Hi,

I'm looking for a macro to use in excel 2010 that will insert 2 rows in between every row of data (500 rows) in a sheet? Any help, greatly appreciated. If possible could you also explain to me how to edit the macro to insert 1 row only or to edit the data range for example?

Also, can anyone recommend a good book for writing macros & using formula with vba etc?


Thanks,

Louise

[rollis13]

Have a try with this macro placed in the sheets VB code module.
No empty rows expected in the used range.

Please Login or Register  to view this content.

[Louise H]

Hi, thanks a mill. This was really helpful and works perfectly.

Louise

[rollis13]

Glad been of some help .