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

[µo°Ý] vba ¦p¦ó°Ñ·ÓÀx¦s®æ¨Ó¿ï¾Ü¤u§@ªí

[µo°Ý] vba ¦p¦ó°Ñ·ÓÀx¦s®æ¨Ó¿ï¾Ü¤u§@ªí

­ì¥»¬O¦bSheet1
A1 ¬O Sheet2

¦p¦ó¦bVBA °Ñ·ÓSheet1ªºA1 ¨Ó select Sheet2?

worksheets(sheet1.cells(1,1).value).select

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD