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

[µo°Ý] ¦p¦ó±qsheet1 Àx¦s¦ÜSheet3

³o¤@ÃD¤j®a¦^ÂЪº«Ü¿ãÅD
¦ý¦³ÂI½ÆÂø¤Æ¤F
*********************************
§Ú­Ì¨Ó¬Ý¬Ý³o¤@ÃD¬°¤°»ò®L¥S
¦^ªº«Ü§®ªº­ì¦]

§Ú¬Ý¤F«Ü»{¦P®L¥Sªº°µªk
¤]«Ü¦³·PIJ³o«Ü­«­n
­º¥ý¬OÆ[©À©Ê°ÝÃD OFFICE¯à¥Î°ò¥»¥\¯à´N¥Î°ò¥»¥\¯à ¯à¤£¥Î¥¨¶°´NºÉ¶q¤£¥Î¥¨¶°
¦b³o­ì«h¤U®L¥S°µ¨ì¤F¥Î©w¸q¨ç¼Æ¹Bºâ¥Dµ{¦¡µM«á¦A±Nµ²ªG©ñ¨ì¥¨¶°
´N³æ³o¨â¦æ©w¸q ºâ¥X¤F½Æ»s°Ï»P­n¶K¨ì­þ¸Ìªº©w¦ìÂI
A=OFFSET(Sheet1!$B$6,,,COUNTA(Sheet1!$B$6B$25),7)
N=OFFSET(Sheet3!$B$5,COUNTA(Sheet3!$B$5B$65536),)

TOP

±z¦n~§Ú­è­è¶}©l¾ÇµÛ»s§@¤@¨Çexcel ¥\¯à,§Ú¹J¨ì¦P¼Ëªº°ÝÃD,¦Ó§ó¤£ÁA¸Ñ¦p¦ó»s§@Àx¦s«ö¶s( CommandButton1_Click() ) ,¦ý¬O§Ú¬O·s¦¨­û,©Ò¥HµLªk¤U¸ü¦U¦ì«e½úªº½d¨Ò¨Ó¬ã¨s,©Ò¥H¦U¦ì«e½ú¥i§_¦A±Ð¨|¤@¤U¤p§Ì,©Î¥i¥H±N«e½úªº½d¨Ò±Hµ¹§Ú©O? [email protected] ,·P®¦.
Steven

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD