¬°¤°»ò§ÚªºExcel ¤£·|°Ê ??
- ©«¤l
- 117
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 155
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-8-29
|
¬°¤°»ò§ÚªºExcel ¤£·|°Ê ??
¥»©«³Ì«á¥Ñ color790 ©ó 2011-11-11 17:29 ½s¿è
°Ý¤@ӫܲʲLªº°ÝÃD.....(¤£¹L§Ú§Ö³Q·dºÆ¤F)
¥Dn¬O·Q¥Îª©¥DGBKEE ³o¤@¬qµ{¦¡ http://forum.twbts.com/thread-4188-1-1.html
¥u¬O³£µLªk°Ê,©Ò¥H§ä¤F¥H¤U³Ì²³æªºµ{¦¡¨Ó¸Õ¸Õµ²ªG¤]¤£¦æ,
Private Sub Worksheet_Calculate()
Range("b1").End(xlDown).Offset(1) = Range("a1")
End Sub
·N«äÀ³¸Ó¬O[A1]¦pªGÅÜ°Ê,¦bBÄæ·|°O¿ý¤U¨Ó, ¥i¬O¬°¤°»ò§ÚªºExcel ¤£·|°Ê ??
µ{¦¡¼g¦b¤u§@ªí1¤]¤£·|°Ê, ThisWorkbook¤]¤£·|°Ê
¬¡¶Ã¯2.rar (10.9 KB)
|
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 117
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 155
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-8-29
|
観«¸Õ¤@¤U, §Ú¥ÎDDE, ¼Æ¾Ú½T©w·|°Ê, ¦ýBÄæ«o³£¤£·|°Ê
ÁÙ¬O»¡n³]©wþÃä, ¯u©_©Ç |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 117
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 155
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-8-29
|
¥i¥H¤F.... µ²ªG¯uªº«Ü©_©Ç
¦n¹³n¦b¥¨¶°³]©w¸Ì, ÂI¿ï "±Ò¥Î©Ò¦³¥¨¶°(......) "
¥H«e³£ÂI¿ï "°£¤F¸g¼Æ¦ìñ³¹ªº¥¨¶°¥~,°±¥Î©Ò¦³¥¨¶°" , ¶}Àɮ׫ö±Ò¥Î¥¨¶°´N¥i¨Ï¥Î¥¨¶°
³oÓ©~µM¤£¦æ.....
¤£¹LÁ`ºâ¥i¥Î¤F, ±ß¤@ÂI¦A¨Ó¸Õ¸ÕGBKEEªºµ{¦¡
ÁÂÁ¤j®aªºÀ°¦£, ¦pªG¦³°ÝÃD,¦A³Â·Ð¦U¦ìÀ°¦£¸Ñµª...... ^^ |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 117
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 155
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-8-29
|
HI~GBKEEª©¥D
è¥Î§A¼gªºµ{¦¡, ¤S¤£·|°Ê¤F
¥i§_³Â·Ð§AÀ°§Ú¬Ý¤@¤U(§Ú¦³×§ï®É¶¡¤Î¤@ÂIÂI¨ä¥Lªº)
¬¡¶Ã¯2.rar (16.12 KB)
|
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 117
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 155
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-8-29
|
ª©¥D,§Ú¤£¤ÓÀ´
§ÚD1²{¦b¬O³] 10:00:00 PM , B1¬O09:00:00 AM
¥Ñ©ó¬O§ì¥~°êªºDDE©Ò¥H¥Ø«e³£·|°Ê, ¤]³]¥ß¤¤Â_ÂI, ¤]«ö F2 ¦A«ö Enter
¦ý¦bVBAµøµ¡«öF8³£¬O¨ì©|¥¼¶}½L¤U¤@¦æ´N¤S°j°é¤F, ³o¬O¬°¤°»ò? |
|
ªì¾ÇªÌcolor
|
|
|
|
|
- ©«¤l
- 117
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 155
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2024-8-29
|
ª©¥D¤£n³o»ò»¡, §AªÖÀ°¦£¤w¸g«Ü¦n¤F....
¥Ñ©ó²{¦b¬O°²¤é¨S¦³DDE¨Ó·½¥i¥Î, §«ô¤@¦A¨Ó§¹¾ãªº¨Ï¥Î¬Ý¬Ý,
¦pªG¥Îª©¥Dªº¤èªk(³]¤¤Â_ÂI,«öF8´ú¸Õ), ·|¦b³o¤@¦æ°±¤î
Tr = Int((Time - startTime) / Time_Step) + 30
´«¦¨¥t¤@¦æOK
Tr = Int((Time - startTime) * 1440) +30 |
|
ªì¾ÇªÌcolor
|
|
|
|
|