¥»©«³Ì«á¥Ñ t8899 ©ó 2014-4-28 07:37 ½s¿è
§Ú·Q§äAÄæ ˼ƲĤ@Ó¤p©ó TimeValue("12:48:20") ¥k²¾¤@®æ(BÄæ)
¦A²ÎpB1¨ì¦¹®æªº¦Xp
©Î¦³§ó¦nªº¼gªk??
Book2.rar (7.67 KB)
Sub aaa()
Dim x As Date
x = TimeValue("12:48:20")
For k = 1 To 165 Step -1
If Cells(k, 1) < x Then
Set t = Cells(k, 1).Offset(0, 1)
t.Offset(t, t, 0, -counta(range("b26:"& t), 1).Select
Exit For
End If
Next
End Sub |