EXCEL高手用VBA解释一下for循环MIDleftirghtxy
A="ABBACDDCBA"
for i=6 to 2 step -2
X=mid(A,i,i)
Y=left(A,i)
Z=right(A,i)
Z=X & Y & Z
next i
print z
A,ABA
B,AABAAB
C,BBABBA
D,ABBABA
为什么选C
i=6,Z=....... (不用)
i=4,Z=........(不用)
i=2,X=mid(A,2,2)="BB",Y=left(A,2)="AB",Z=right(A,2)="BA"
Z=X & Y & Z="BB" & "AB" & "BA"="BBABBA"
|