|
改用 Select Case 吧,用以下代码替换:
- For Each SHT In Worksheets
- Select Case SHT.Name
- Case strTarget, "统计" '' 把不需要统计的 Sheet 名称都放这里
- Case Else
- iRow = SHT.Range("A" & iRowHeader).End(xlDown).Row
- strValue = SHT.Range("A" & iRow).Value
- If iRow > iRowHeader And strValue <> "" And InStr(strValue, "合计") = 0 Then
- ' 若数据表内有数据才处理
- arrRows = iRow - iRowHeader
- ReDim arrSrc(1 To arrRows, 1 To arrCols)
- arrSrc = SHT.Range("A" & iRowHeader + 1).Resize(arrRows, arrCols).Value
-
- ' 写入汇总表
- Rng.Resize(arrRows).Value = SHT.Name
- Rng.Offset(, 1).Resize(arrRows, arrCols).Value = arrSrc
- Set Rng = Rng.Offset(arrRows)
- End If
- End Select
- Next
复制代码 |
评分
-
查看全部评分
|