¦p¦óÁקKÀx¦s®æ¤½¦¡¡A¦]¡y°Å¤U¡z¡y¶K¤W¡z¦Ó³Qקï¡H
- ©«¤l
- 79
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 123
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- x64
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2013-10-24
- ³Ì«áµn¿ý
- 2024-3-28
|
¦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¬¡¡^
|
|
|
|
|
- ©«¤l
- 79
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 123
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- x64
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2013-10-24
- ³Ì«áµn¿ý
- 2024-3-28
|
¦^´_ 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¬¡¡^
|
|
|
|
|