EXCEL高手用VBA解释一下for循环IJNEXTADF
private sub command1_click()
dim a1(4,4),a2(4,4)
for i=1 to 4
for j=1 to 4
a1(i,j)=i+j
a2(i,j)=a1(i,j)+i+j
next j
next i
print a1(3,3);a2(3,3)
end sub
输出(D)
A,6 6
B,10 5
C,7 21
D,6 12
为什么选D
a1(3,3),a2(3,3) 此时i 和 j 都是3
那么代入到循环语句里面
a1(3,3)=i+j=3+3=6
a2(3,3)=a1(3,3)+i+j=6+3+3=12
|