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

[µo°Ý] °O¿ý¨C¤é¤£¦Pªº¼Æ¾Ú

[µo°Ý] °O¿ý¨C¤é¤£¦Pªº¼Æ¾Ú

½Ð±Ð°ª¤â¦Ñ®v:
±ý±N¨C¤é¤£¦P¼Æ¾Ú..«ö¨C¤@ªÅ¥Õ¦C¨Ì§Ç©¹¤U°O¿ý..
½Ð±Ð±±¨î¶µVB ¦p¦ó®Ñ¼g? ªþ¥ó¤º¦³»¡©ú! ¬ö¿ý.rar (10.64 KB)

¦^´_ 1# duck_simon


    ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò,«á¾Ç«Øij¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò

Option Explicit
Sub TEST()
Dim Brr, xR As Range
Brr = [B17:K17]
Set xR = Cells(Rows.Count, "B").End(3)(2).Resize(, 10)
xR = Brr
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 2# Andy2483


    ·PÁ¤j¤j°ª¤H..¦n¥Î ÁÂÁÂ

TOP

¦^´_ 2# Andy2483


    ©I¥s¤j¤j:  ÁV¤F.§Ú¤@ª½¥X²{: ¤£¥¿½Tªº¦WºÙ  Åܦ¨¥Xª¬ªp¤F

TOP

¦^´_ 4# duck_simon


    ½Ð«e½ú¤W¶Ç¥X¿ùªºÀÉ®×
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

½Ð°Ý¦Ñ®v:  ¬O¤£¬O¦WºÙ­n§ï? ¥i§_±NVB¼g¤JÀÉ®×À£ÁY? ¦Ñ¦´¤£¤~..³oVB¹ê¦b¤£À´..
               
¤W¶Çªþ¥ó¤¤¤w¸g¦³¶}±Ò¨Ï¥Î¥¨¶°..
¤S½Ð°Ý¨C¤@¤u§@ªí¬O§_­­¨î¤T­ÓACTIVEX?
¦p§ï¼gActive x ­n¦p¦ó¼g ?  ÁÂÁ±z! ¬ö¿ý.rar (17.34 KB)

TOP

¦^´_ 6# duck_simon


    ½Ð«e½ú¸Õ¸Õ¬Ý
¬ö¿ý_20241018_1.zip (20.06 KB)
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 7# Andy2483


    ·PÁ¤j®v±z!  ¨S°ÝÃD¤F..¥i¯à¬O(¤è«K§Ú°Ï§O)§Ú¥h§ï²Ä¤@¦æ..§Ú¹ê¦b¤£À´ªº..ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD