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

¦p¦óÁקKÀx¦s®æ¤½¦¡¡A¦]¡y°Å¤U¡z¡y¶K¤W¡z¦Ó³Q­×§ï¡H

¦p¦óÁקKÀx¦s®æ¤½¦¡¡A¦]¡y°Å¤U¡z¡y¶K¤W¡z¦Ó³Q­×§ï¡H

¦p¦óÁקKÀx¦s®æ¤½¦¡¡A¦]¡y°Å¤U¡z¡y¶K¤W¡z¦Ó³Q­×§ï¡H

sheet2 a1= Sheet1!a1
sheet2 b1= Sheet1!b1
sheet2 c1= Sheet1!c1

sheet2 a2= Sheet1!a2
sheet2 b2= Sheet1!b2
sheet2 c2= Sheet1!c2

¥H¦¹Ãþ±À

§Ú­n©T©w sheet2 ªº¤½¦¡¡A¤£¯à¦]¬° sheet1 ªºÀx¦s®æ ¡y°Å¤U¡z¡y¶K¤W¡z¦Ó³Q­×§ï


¤@¡B§Ú¸Õ¤F±N sheet2 ¤u¨ã->«OÅ@->«OÅ@¤u§@ªí

µ²ªG¡y°Å¤U¡z¡y¶K¤W¡z ¤½¦¡ÁÙ¬OÅܤF


¤G¡B§Ú¸ÕµÛ¥Îindirect("Sheet1!a1",1)ªº¤è¦¡¨Ó¨ú¥N¡A¤½¦¡¬O¤£·|ÅܤF¡A

¬ÛÃö¤½¦¡¦@¦³ 15453­Ó, µ{¦¡®e¶q«o¤j¤F30%¡A¦h¤F750k ¡A¾ã­ÓÀɮתº¶}±Ò³t«×¤]ÅܺC¤F

¬°¤F²£¥Í15453­Ó¤½¦¡¡A§ÚÁÙ¨è·N¥Î vba ¨Ó²£¥Í¡C



¤T¡B¥Ø«e§ÚÁÙ¯à·Q¨ìªº´N¬O¦b¼g­Ó¥¨¶°¡A¦bµ{¦¡¶}±Ò°Ê¡A¥D°Ê§ó·s¾ã­Ó sheet2ªº¤½¦¡¡A

³o¼Ëªº¤è¦¡¡A¤£¯à½T«O¶}±Ò«á¤½¦¡¤£³Q¨Ï¥ÎªÌ­×§ï

¨Ï¥ÎªÌ¤U¦¸­«·s¶}±Ò¤~¯à½T«Osheet2 ¤½¦¡¥¿½T¡C


ÁÙ¦³§ó¦nªº°µªk¶Ü¡H
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

¦^´_ 2# ikboy


    ÁÂÁ¡A¤£¯àª½±µ¶ñ­È¡A¥u¯à¤½¦¡

§Ú¸Õ¤F indirect offset index

¥Ø«e¬Ý¨Ó index ³Ì¬ÙªÅ¶¡~~  index < offset < indirect

¦Ó¥Bª½±µ¶ñ¼g 1 2 3 4 ·|¤ñ¥Î row() column() ¬ÙªÅ¶¡

§ÚÁÙ¬O°µ¤@­Ó³Q°Ê¤è¦¡¨Ó³B²z¡A¤]³\´N¹³¤W­±ªº worksheet_activate ®É¤~§ó·s¤@¦¸©Ò¦³¤½¦¡~~
¤½¶}¸gÅç¡A³Ð³y´¼¼z¡]§Ú¤S¤£¾a³o¹L¬¡¡^

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD