Sub 查找()
Dim Rng As Range
Dim Hang%, jiaoshi$
Dim arr, brr(0 To 9, 1 To 6), i%, x%, y%
jiaoshi = Sheets("教师课表").Range("e1")
With Worksheets("课表")
Hang = .Range("b:b").Find(jiaoshi).Row
arr = .Cells(Hang, 4).Resize(1, 58)
For i = 1 To 58
If i > 49 Then
x = i Mod 10
y = i \ 10 + 1
Else
x = (i - 1) Mod 10
y = (i - 1) \ 10 + 1
End If
brr(x, y) = arr(1, i)
Next i
End With
Range("c4").Resize(10, 6) = brr
End Sub
把星期三多余的第9节灭掉以后,用这代码