|
楼主 |
发表于 2013-6-3 10:25
|
显示全部楼层
lyf7276 发表于 2013-6-3 08:41
是不是你想要的结果?记得来个最佳。
我把你最终的代码贴上来秀下:
Sub kl()
Range("a2:df11").Interior.Color = Range("a2000").Interior.Color
mm = Minute(Range("h2"))
mc = DateDiff("n", Range("h2"), Range("df2"))
For i = mm To mc / 10
Cells(3, 8 + i).Interior.Color = 30000
Next
For t = 4 To 11
m1 = DateDiff("n", Range("h2"), Range("d" & t))
If Range("e" & t) = "" Then
m2 = 1020
m3 = 1020
Else
m2 = DateDiff("n", Range("h2"), Range("e" & t))
m3 = DateDiff("n", Range("h2"), Range("f" & t))
m4 = DateDiff("n", Range("h2"), Range("g" & t))
End If
For i = (m1 - mm) / 10 To (m2 - mm) / 10
Cells(t, 8 + i).Interior.Color = 50000
Next
For i = (m3 - mm) / 10 To (m4 - mm) / 10
Cells(t, 8 + i).Interior.Color = 50000
Next
Next
End Sub
谢谢你的帮助!
|
|