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

[µo°Ý] ½Ð±Ð:§Q¥Î¦Û­qªí³æ¶K¤W³]©w¦nªº¤½¦¡

[µo°Ý] ½Ð±Ð:§Q¥Î¦Û­qªí³æ¶K¤W³]©w¦nªº¤½¦¡

¥»©«³Ì«á¥Ñ minture3 ©ó 2015-4-14 12:18 ½s¿è

½Ð±Ð¦U¦ì
¤p§Ì·Q­n§Q¥Î¦Û­qªºªí³æ¦p¤U¹Ï
ÂI¿ï¤è®×¤@«á

´N¹³³o¼ËÀ°§Ú§â¦b¥t¥~¤@­ÓEXCELÀɮפ¤ªº¤è®×¤@­pºâ¤½¦¡½Æ»s¹L¨Ó¨Ã¶K¤W§Ú¥Ø«e©Ò¦b¦ì¸mªºÀx¦s®æ

½Ð±Ð¦U¦ìµ{¦¡½XÀ³¸Ó«ç»ò¼g?
¥H¤U¬O¤p§Ì°Ñ¦Ò¿ý»s¥¨¶°ªº¤è¦¡­×§ïªº
¦ý¬O°õ¦æ«á·|¦³°ÝÃD
userform1.show 0

Windows("¤è®×¤½¦¡.xls").Activate
Sheets("sheet1").Rows("5:15").Select
Application.CutCopyMode = False
    Selection.Copy
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
   ActiveSheet.Paste

½Ð±Ð¦U¦ì
¤p§Ì·Q­n§Q¥Î¦Û­qªºªí³æ¦p¤U¹Ï
ÂI¿ï¤è®×¤@«á

´N¹³³o¼ËÀ°§Ú§â¦b¥t¥~¤@­ÓEXCELÀɮפ¤ªº¤è®×¤@­p ...
minture3 µoªí©ó 2015-4-14 12:17

¸Õ¸Õ

Workbooks("¤è®×¤½¦¡.xls").Sheets("sheet1").Rows("5:15").Copy Workbooks("¥ØªºÀÉ®×(¤u§@ï)¦W").Sheets("sheet1").[A1]

TOP

¥»©«³Ì«á¥Ñ minture3 ©ó 2015-4-16 08:52 ½s¿è

¦^´_ 2# luhpro

·PÁ¦^ÂÐ
¦ý¬O§Ú§Æ±æªº¬O¼u¥X¦Û­qªí³æ«á
¿ï¤¤Àx¦s®æ¤¤ªº¬Y¤@®æ ÂI¿ï¦Û­qªí³æ¤W­±ªº¤è®×¤@(or¤è®×¤G)
´Nª½±µ§â¥t¥~¤@³¹¤u§@ªí¤¤ªº¤è®×¤@(or¤è®×¤G)ªº¤½¦¡¶K¤W

TOP

¦^´_ 3# minture3

¸Õ¸Õ¬Ý
    Location = Selection.Row
    Workbooks("¤è®×¤½¦¡.xls").Sheets("sheet1").Rows("5:15").Copy Workbooks("¥ØªºÀÉ®×(¤u§@ï)¦W").Sheets("sheet1").Rows(Location)
PKKO

TOP

¦^´_ 4# PKKO


    ·PÁÂ!! ´ú¸Õ¹L¬O§Ú­nªº  §Ú¦b¦Û¤v­×¥¿¤@¤U!!

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD