|
Sub 批量复制()
Dim arr, x&
arr = Sheets("數據源").[a1].CurrentRegion
Sheets("樣板").Copy
With ActiveSheet
For x = 3 To UBound(arr)
.[D6:D7] = Application.Transpose(Array(arr(x, 3), arr(x, 4)))
.[D9:D11] = Application.Transpose(Array(arr(x, 8), arr(x, 14), arr(x, 16)))
.[H6:H7] = Application.Transpose(Array(arr(x, 2), arr(x, 6)))
.[H9:H11] = Application.Transpose(Array(arr(x, 10), arr(x, 15), arr(x, 22)))
.Name = arr(x, 3)
ActiveWorkbook.SaveCopyAs ThisWorkbook.Path & "\" & arr(x, 3) & ".xls"
Next
End With
ActiveWorkbook.Close False
End Sub |
评分
-
查看全部评分
|