Need help from Gurus here !!!

來源: cg333 於 2004-12-20 11:03:19 [] [舊帖] [給我悄悄話] 閱讀數 : (255 bytes)

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

請您先登陸，再發跟帖！