|
有点意思
- Sub lkyy()
- Dim wb As Workbook
- gtw = Application.GetOpenFilename(filefilter:="Excel(*xls文件),*.xls", MultiSelect:=True)
- For a = 1 To Sheets.Count
- tn = ThisWorkbook.Sheets(a).Name
- Dim br(1 To 50, 1 To 3)
- For j = 1 To 3
- br(1, j) = Cells(1, j).Value
- Next
- For Each g In gtw
- N = N + 1
- Set wb = Workbooks.Open(g)
- ar = wb.Sheets(tn).Range("a1").CurrentRegion
- wb.Close 0
- Set wb = Nothing
- For i = 2 To UBound(ar)
- For j = 1 To 3
- br(i, j) = br(i, j) + ar(i, j)
- Next j, i
- Next
- Sheets(a).Range("a1").Resize(50, 3) = br
- For i = 2 To 50
- For j = 1 To 3
- If Sheets(a).Cells(i, j).Interior.ColorIndex = xlNone Then Sheets(a).Cells(i, j).ClearContents
- Next j, i
- Next a
- End Sub
复制代码 |
|