wsClass As Worksheet

冷茶视界 2024-10-01 发布于江苏 | 转藏 内容提要 根据总课表统计教师任课表、班级任课表|完整代码 1、在工作表“总课表”里，命令按钮点击事件，调用汇总统计过程： Private Sub CmdSum_Click() Call mySumEnd Sub 2、在myModule模块里，mySum主过程，汇总统计课时数据： Option ExplicitDim ws As Worksheet, lastRow As Integer, lastCol As IntegerDim wsTeacher As Worksheet, wsClass As Worksheet, rng As RangeDim arr(), temp(), dic1 As Object, dic2 As Object, dicSubject As Object, dkeyDim iRow As Integer, iCol As Integer, i As Integer, j As Integer, m As Integer, n As IntegerDim class, teacher,...