Sub test() Dim a a = [a1:d10] [f1].Resize(UBound(a), 1) = Application.Index(a, 0, 0) '返回第1列 [g1].Resize(UBound(a), 1) = Application.Index(a, 0, 1) '与上句等效 End Sub
Sub test() Dim a a = [a1:d10] [f1].Resize(UBound(a), 1) = Application.Index(a, 0, 0) '返回第1列 [g1].Resize(UBound(a), 1) = Application.Index(a, 0, 1) '与上句等效 End Sub