|
发表于 2016-3-23 11:38
|
显示全部楼层
本楼为最佳答案
- Sub 个人课程表()
- arr = Sheet1.Range("a1:bh43")
- Dim brr(1 To 8, 1 To 5)
- With Sheet2
- For n = 1 To 2
- If n = 1 Then js = .[d2] Else js = .[d15] '老师
- For i = 4 To UBound(arr)
- c = Int((i + 4.1) / 8) '行数对应Brr列(星期)
- r = arr(i, 2) '每天课数对应brr行
- For j = 4 To UBound(arr, 2) Step 2
- If arr(i, j) = js Then brr(r, c) = brr(r, c) & Chr(10) & arr(3, j - 1) & "/" & arr(i, j - 1)
- Next
- brr(r, c) = Mid(brr(r, c), 2)
- Next
- If n = 1 Then .[b5].Resize(8, 5) = brr Else .[b17].Resize(8, 5) = brr
- Erase brr
- Next
- End With
- End Sub
复制代码 |
|