¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-2-25 13:30 ½s¿è
hsieh«e½ú§A¦n!
°¸¹³«e½ú!¤£¦n·N«ä½ÐÀ°¦£¬Ý¬Ý
¬°¦ó°õ¦æ³oÓµ{¦¡
With Sheet1
Set Rng = .Cells.Find(Format(Date, "[$-404]m/d"), LookIn:=xlValues, LookAt:=xlWhole)
.Select
If Not Rng Is Nothing Then Rng.Offset(, 1).Select Else MsgBox "§ä¤£¤u§@¤Ñ"
End With
End Sub
´N½Ä¬ð¨ì¥¦
Set Age_Rng(0) = Range(Age_Rng(1).Offset(, 6), Age_Rng(2).Offset(, 6))
°ÝÃD¦pªþÀÉ»¡©ú
½Ð³Â·Ð«ü¾ÉÁÂÁ¦A¤T!! |