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

¤À¨É¤@­Ó²³æªº¶Ç¦^¸ê®Æ¤Î¹Ï¤ùÀÉ

¤À¨É¤@­Ó²³æªº¶Ç¦^¸ê®Æ¤Î¹Ï¤ùÀÉ

¤À¨É¤@­Ó²³æªº¶Ç¦^¸ê®Æ¤Î¹Ï¤ùÀÉ,  

AA.rar (214.04 KB)

¤£¿ùªººc·Q,¹³¤ùªºÅã¥Ü§Q¥Î¹Ï¤ù·Ó¬Û¥\¯à,¶Ç¦^°Ñ·Ó¦ì¸mªº¼v¹³(¹Ï¤ù,¤å¦r..µ¥)

TOP

¦^´_ 2# GBKEE
ÁÂÁÂ, ¨ä¹ê¦b³o¤è­±ªº¹B¥Î, ÁÙ¬O¤p¾Ç¥Í,
­ì¥»³oÀɮפº¬O¦h¤u§@ªí, ¥¿¥Ñ©ó¦h¤u§@ªíÃö«Y, ¥Î®a­Y­n¬d¸ß¶µ¥Ø«K¸û¶O®É, ¬G§â»Ý­n¬d®Ö¶°¤¤©ó¬d¸ßªí¤º, ³o¬O¤À¨É¤@ÂI¨à¤ß±o¦Ó¤w..

TOP

§Ú¦b­û¤u¸ê®Æ¤u§@ªíéÁ¥[¤@¦C, ¦Óµ{¦¡½X¥çÅܧó½d³ò, ¦ý¬°¦ó¬d¸ßªí¤¤ªº¤U©Ô·j´M¤£¨ì¸ê®Æ, ½Ð¤j¤j­Ì±Ð¾É, ÁÂÁÂ
55.rar (395.67 KB)

TOP

¦^´_ 4# ©P¤j°¶


    ½d³ò¦C = Sheets("­û¤u¸ê®Æ").Cells(1, 1).End(xlDown).Row
§A¬Ý±o¨ì½d³ò¦Cªº¼Æ­È¬O¦h¤Ö?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh
ÁÂÁ¤j¤j,
©ú¥Õ¤F, ·PÁ¦^À³..·P®¦..

TOP

¥»©«³Ì«á¥Ñ yanto913 ©ó 2012-12-13 21:52 ½s¿è

¨Ï¥Î"317 "¤j¤jªºAA.xls¡A­×§ï³s¥~³¡xls«ç»ò³s³£³s¤£¨ì
¬d¬Ý¤FADDRESS¨ç¼Æ
http://office.microsoft.com/zh-tw/excel-help/HP010062407.aspx
À³¸Ó¤]¨S³]¿ù¡A¦ý¬O´N¬O·|¥X²{#REF!
¥H¤UOK
=INDIRECT(ADDRESS(2,2,1,1,"Sheet2"))
¦ý¥H¤U´NNG¤F(Book1.xls¤w¦³¶}±Ò)
=INDIRECT(ADDRESS(2,2,1,1,"[book1]Sheet2"))
YOYO

TOP

¤£¿ùªººc·Q,¹³¤ùªºÅã¥Ü§Q¥Î¹Ï¤ù·Ó¬Û¥\¯à,¶Ç¦^°Ñ·Ó¦ì¸mªº¼v¹³(¹Ï¤ù,¤å¦r..µ¥)
GBKEE µoªí©ó 2011-7-9 11:21

¹Ï¤ù·Ó¬Û¥\¯à¡B¥H¤Î¶Ç¦^°Ñ·Ó¦ì¸mªº¼v¹³(¹Ï¤ù,¤å¦r..µ¥)
§Ú«D±`¦n©_¡A¥¦­Ì¤§¶¡¬O¦p¦ó¹ïÀ³ªº¡H³]©w¤è­±¦³¦ó¬ªù¡H
¯u¤£¦n·N«ä¡A³o¤è­±ªºª¾ÃѧګD±`½§²L¡I

TOP

¦^´_ 7# yanto913
§âÀɮפW¶Ç,

TOP

¦^´_ 8# c_c_lai
§Q¥Î¦WºÙ°t¦X¨ç¼Æ, ¥i±q¤u¨ã¦C«ö¨ú®ø±K½X, ¦A¨ì¦WºÙºÞ²z¬Ý¦WºÙ³]©w..

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD