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

[µo°Ý] ÂI¿ïÀx¦s®æ¤ºªº¶W³sµ²,µ{¦¡½XÀ³­n¦p¦ó¼g?

[µo°Ý] ÂI¿ïÀx¦s®æ¤ºªº¶W³sµ²,µ{¦¡½XÀ³­n¦p¦ó¼g?

½Ð±Ð¤j¤j
ÂI¿ïÀx¦s®æ¤ºªº¶W³sµ²,µ{¦¡½XÀ³­n¦p¦ó¼g?
ÁÂÁÂÁٽФj¤jÀ°¦£«ü±Ð

·N«ä¬O¥Î VBA ÂI¿ï¶W³sµ²¶Ü

TOP

¦^´_ 1# blue2263


    B1ªº¶W³sµ²
Range("B1").Hyperlinks(1).Follow
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂGª©¤j¸Ñµª
¦^´_Gª©¤j¿ý»s¥¨¶°,§Ú¤§«e¦³¸Õ¹L,¦]§Ú¶W³s±µ¤º¦³¨ç¼Æ
=HYPERLINK("[AÀ禬.xlsb]"&B2&"!a1", B2&"¶W³sµ²")
¶]¥X¨Óªº·|¬O¦p¤U«ü¥O½X
Application.Goto Reference:="'10302'!R1C1"
¦]§Æ±æ10302¤u§@ªí¬OÅܼÆ,©Ò¥H¿ý»s¥¨¶°ªºµ{¦¡½XµLªk¥Î

TOP

¦^´_ 3# Hsieh

Hª©¤jÁÂÁÂ
§Ú´ú¸Õ°_¨Ó¦p¬°¥¿±`ªº¶W³sµ²,µ{¦¡½X¬OOKªº
¦ý¦pªG¶W³sµ²¬O¥Î¨ç¼Æ°µªº¦p¤U,µ{¦¡½X·|µLªk°õ¦æ
=HYPERLINK("[AÀ禬.xlsb]"&B2&"!a1", B2&"¶W³sµ²")
½Ð±Ð­n¦p¦ó§ó§ï,ÁÂÁÂ!!

TOP

¦^´_ 4# blue2263

¤£¬O¸Ñ¨M¤F

Application.Goto Reference:=ÅÜ¼Æ &"!R1C1"
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD