- ©«¤l
- 31
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taipe
- µù¥U®É¶¡
- 2011-4-29
- ³Ì«áµn¿ý
- 2014-1-20
|
¦^´_ 4# GBKEE
·PÁªO¤j¤w¸g¥i¥Hrun¤F
½Ð°Ý¤@¤U Cells(2====> ¬O«ü¨âÓ¶µ¥ØÅܰʼg2 Y¤T¶µ´N¼g3 ½Ð°Ý³o¼Ë×¥¿¶Ü ¥H¤U½X¤£ºû«ù¤£ÅÜ
Set Rng = .Cells(2, Columns.Count).End(xlToLeft).Offset(, 1) '°O¿ý¤U¨Óªº¦ì¸m
Rng.Resize(, 2) = T
Rng.Offset(1).Resize(3, 2) = Sheets("Sheet1").Range("C1").Resize(3, 2).Value
Rng.Resize(, 2).EntireColumn.AutoFit
ÁÙ¦³¤@Ó·Q°Ý¬O¤@¤ÀÄÁªº¸Ü ¬O¤£¬Oצ¨¥H¤U³o¼Ë´N¦n¤F
If Minute(T) Mod 1Then
T = TimeSerial(Hour(T), Minute(T) + (1 - Minute(T) Mod 1), 0) |
|