ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

tick¸ê®ÆÂà´«¤ÀÄÁ¸ê®Æ(¤w¤U¸ü¸ê®Æ)

tick¸ê®ÆÂà´«¤ÀÄÁ¸ê®Æ(¤w¤U¸ü¸ê®Æ)

§Ú¤w¸g¤U¸ü·í¤Ñ®É¶¡¸ê®Æ¡A
·Q±NTick¦UºØÀW²v¸ê®ÆÂà´«¦¨
1¡N5¡N10¡N30¡N60¤ÀÄÁ¸ê®Æ¡C
¤£ª¾¹D«ç»ò¼gµ{¦¡¶Ü??
³Â·Ð¦U¦ìÀ°À°§Ú~~

¸ê®Æ20150116.rar (877.8 KB)

·PÁ¤j¤j«ü±Ð~~
¦ý¦³¨Çªþ¥óÁÙ¨S¦³Åv­­¥i¥H°Ñ¦Ò¹ê¦b«ÜÃø¦³ÀYºü¡C
¦b¦³¸ê®Æ®É«Ü¶¶¡A¦ý¦b¨S¸ê®Æ®É...¦p¦ó§ä¤W¤@µ§¸ê®Æ¡C
With Worksheets("1¤ÀÄÁ")
Onerow = .Range("a1048576").End(xlUp).Row

.Range("C2") = Worksheets("TICK").Range("E2")
Findum = Worksheets("TICK").Range("D21048576").Find(.Range("B" & 2)).Row
End With
¦ý¤£¬O¨C¤@¤ÀÄÁ³£¦³¸ê®Æ¡A¹³¬O91200´N§ä¤£¨ì¸ê®Æ¡A¨º­n«ç»ò§ä¨ì¤W¤@µ§¸ê®Æ¡C

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD