Need help from Gurus here !!!

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 -ComeInside- 给 ComeInside 发送悄悄话 (441 bytes) () 12/20/2004 postreply 12:11:47

You are so great, -I'mnaive.- 给 I'mnaive. 发送悄悄话 (0 bytes) () 12/20/2004 postreply 17:03:12

回复:U R 2 naive! Here's the method -cg333- 给 cg333 发送悄悄话 (248 bytes) () 12/20/2004 postreply 19:02:38

你所谓的那些ITguys不过是些略通高科技的蓝领工人,钟点工 -ComeInside- 给 ComeInside 发送悄悄话 (267 bytes) () 12/20/2004 postreply 21:19:51

A macro can fix this easily! -ITguys1- 给 ITguys1 发送悄悄话 (0 bytes) () 12/20/2004 postreply 22:27:03

Try this VBA code -高科技蓝领工人- 给 高科技蓝领工人 发送悄悄话 (766 bytes) () 12/20/2004 postreply 23:02:16

请您先登陆,再发跟帖!