Need help from Gurus here !!! cg3332004-12-20 19:03:19

Does any gurus here know how to add 5 empty rows in an excel documents after each row. I am working on a document which has 2000 rows and wish to add 5 empty rows after each row. I know how to do it manully, I am looking for a way to do it automatically.

U R 2 naive! Here's the method

You are so great,

回复：U R 2 naive! Here's the method

你所谓的那些ITguys不过是些略通高科技的蓝领工人，钟点工

A macro can fix this easily!

Try this VBA code