12972| 15
|
[已解决]工作中的实际问题 批量计算的代码 |
3学分
最佳答案Sub demo()
Application.ScreenUpdating = False
Path = ThisWorkbook.Path & "\"
file = Dir(Path & "*.xlsx")
While file ""
Set wb = Workbooks.Open(Path & file)
[g:g] = ""
c = Range("c1:g" & [a1].End(4).Row)
For i = 1 To UBound(c)
Max = Application.Max(Application.Index(c, i, 0))
Min = Application.Min(Application.Index(c, i, 0))
...
| ||
发表于 2021-6-28 16:20
|
显示全部楼层
本楼为最佳答案
评分 | ||
| ||
发表于 2021-6-29 01:59
|
显示全部楼层
| ||
| ||
发表于 2021-6-29 19:37
|
显示全部楼层
| ||
| ||
发表于 2021-6-29 21:30
|
显示全部楼层
评分 | ||
评分 | ||