1 把Excel某一區域的內容讀入到數組中:數組
Dim strArray() As Variantim
Dim wk_data As Variantant
Set wk_data = Sheets("Sheet1")data
strArray = wk_data.Range("A1:CV100").Value
2 把數組的內容寫入到Excel中
wk_data.Range("A1").Resize(UBound(strArray, 1), UBound(strArray, 2)).Value = strArray