In order to output your array to a range, you need to give it the correct dimensions to output. The best way I find to do this is using the .Resize
property of the specified range. See code below.
MainDataCIB.Sheets("Main Data").Range("A2").Resize(UBound(src,1), UBound(src,2)).Value = src
This approach will ensure that you are giving accurate dimensions to your output.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…