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

[µo°Ý] °Æµ{§Ç°õ¦æ°ÝÃD

[µo°Ý] °Æµ{§Ç°õ¦æ°ÝÃD

½Ð±Ð¦U¦ì¤j¤j¡A¤p§Ì²{¦³¤@­Ó½Æ»s¥\¯à(½Æ»sA1~B4ªº¸ê®Æ¨ìA15)ªº°Æµ{§Ç¡A¦p¦óÅý¦¹°Æµ{§Ç©ó¨C¦¸°õ¦æ®É¥ýÀˬdA15Àx¦s®æ¤º¬O§_¦³µL¸ê®Æ¡A­YµL¸ê®Æ(«üªÅ¥ÕÀx¦s®æ)«h¦Û°Ê°õ¦æ¡A­Y¦³¸ê®Æ«h¤£°õ¦æ¦¹°Æµ{§Ç¡C
§A²q!!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If [a15] = "" Then
        [a1:b4].Copy [a15]
    End If
End Sub
lmh

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD