回復 1#lai.k.h Sub 陣列存取()
Dim Ar()
A = [c3:f5]
For i = LBound(A, 1) To UBound(A, 1)
For j = LBound(A, 2) To UBound(A, 2)
ReDim Preserve Ar(s)
Ar(s) = A(i, j)
s = s + 1
Next
Next
[K11].Resize(s) = Application.Transpose(Ar) '直列
[K11].Resize(1, s) = Ar '橫列
End Sub 作者: lai.k.h 時間: 2011-3-12 17:22