|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
循环的时候,工作表较多,大概有上百个,循环的时间太长了,求大神能优化下代码,本人MAC运行,好像用不了词典~
- Sub Resettled()
- Dim SH As Worksheet
- Dim i, R, arr, s1, s2, s3
- Application.ScreenUpdating = False
- For Each SH In Worksheets
- With SH
- If .Name <> "汇总表" And .Name <> "模板" Then
- .Range("AJ18:AS18").ClearContents
- s1 = .Range("AJ18")
- s2 = .Range("AN18")
- s3 = .Range("AQ18")
- arr = .Range("AJ6").CurrentRegion
- For i = 5 To UBound(arr)
- If arr(i, 6) = "正常安置" Then
- s1 = s1 & arr(i, 1) & ":" & arr(i, 2) & ","
- ElseIf arr(i, 6) = "照顾安置" Then
- s2 = s2 & arr(i, 7) & ","
- ElseIf arr(i, 6) = "优惠购买" Then
- s3 = s3 & arr(i, 7) & ","
- End If
- Next i
- .Range("AJ18") = s1
- .Range("AN18") = s2
- .Range("AQ18") = s3
- End If
- End With
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|