作者walkman (走路男人~)
看板Visual_Basic
标题[VBA ] Excel的新手笨蛋问题
时间Tue Sep 27 16:33:33 2005
我现在先使用自动填满把A1到A16分填上1~16
然後我现在希望用回圈(非COPY)
将他重复动作到E16
变成A1~E16都成为:
1 .1 .1 .1 .1
2 .2 .2 .2 .2
3 .3 .3 .3 .3
. . . . .
. . . . .
16.16.16.16.16
要怎麽写出阿??
麻烦大大了= =a
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.128.142.103
1F：推 sueadolph:For i = 1 To 16 140.118.198.62 10/02 19:22
2F：→ sueadolph:For j = 1 To 16 140.118.198.62 10/02 19:22
3F：→ sueadolph:Worksheets("Sheet1").Cells(i, j).Valu 140.118.198.62 10/02 19:23
4F：→ sueadolph:e = i 140.118.198.62 10/02 19:23
5F：→ sueadolph:Next j 140.118.198.62 10/02 19:24
6F：→ sueadolph:Next i 140.118.198.62 10/02 19:24
7F：推 walkman:谢谢你^^ 61.231.79.7 10/03 00:00