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

[µo°Ý] ½Ð°Ý¤½¦¡°Ñ·Ó#REF!°ÝÃD

[µo°Ý] ½Ð°Ý¤½¦¡°Ñ·Ó#REF!°ÝÃD

½Ð°Ý¦U¦ì¤j¤j!sheet1³¡¤ÀÀx¦s®æ³]©w¤½¦¡°Ñ·Ó¨ìsheet2³¡¤ÀÀx¦s®æ,
¦]¬°sheet2¬°vbaµ{¦¡½X¤u§@°Ï,³¡¤À¦C¸g¹L§R°£¤Î¬ÛÃö¹Bºâ«á
·|³y¦¨sheet1©Ò³]©w¤½¦¡¥X²{#REF!(¦]°Ñ·Óªºsheet2¸Ó¦C¥ý§R°£)
³Â·Ð¨ó§U¦p¦X­×§ï
ÁÂÁÂ

­n¥ý¬Ýsheet1¤½¦¡µ²ºc, ¦A¹w¥ý©Î°õ¦ævba«á³B²z~~
¨S¤W¶ÇÀÉ®×, Ãø²z¸Ñ!!

TOP

«Øij¥Î "INDDIRECT" ±j¨î©T©w©w¸q, ´N¤£·|¦]¬°VBA§R´î¦ÓÅÜ°Ê.

Ex... =INDIRECT("Sheet2!B4")
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD