- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
¦^´_ 37# stillfish00
«á¨Ó§Ú±N¦hÓ»Ýn°Ñ·Óªº¤u§@ªí²¾°Ê¨ì[½d¨Ò-´¡¤J¶W³sµ²],°õ¦æ«ö¶s´N¥i¥H¥¿½TŪ¨ú¸ê®Æ¤F,
¦ý·Q½Ð°Ý«ç»òÅý¥L¥i¥H¶K¤W³sµ²¦Ó¤£¬O¶K¤WÈ©O?
¤W¤@Ó¥¨¶°¥i¥H¶K¤W³sµ²
¤£ª¾¸Ó«ç»ò§ó´«¼gªk®M¤J§Aªº¥¨¶°,Åý¥L¶K¤Wªº®ÉÔ¥i¥H¶K¤W³sµ²- Sub ¶K¤W¸ê®Æ¦Ü_·~°ÈºÞ²z()
- '
- ' ¶K¤W¸ê®Æ¦Ü_·~°ÈºÞ²z ¥¨¶°
- '
-
- Range("A3:P3").Copy
- Windows("«È¤á©ú²Ó-·~°È±M¥Î.xlsm").Activate
- EndRow = Windows("«È¤á©ú²Ó-·~°È±M¥Î.xlsm").ActiveSheet.Range(Cells(Rows.Count, "A").End(xlUp).Address).Row + 1 '©Ò¦³¨Ï¥Î¤¤ªº¦C¼Æ+1
- Windows("«È¤á©ú²Ó-·~°È±M¥Î.xlsm").ActiveSheet.Cells(EndRow, "A").PasteSpecial Paste:=xlPasteValues '¥Ø«e¨Ï¥Î¤¤ªº¤À¶,ªº³Ì¤U¤èªÅ¥Õ¦C¶K¤WÈ
- ActiveSheet.Paste Link:=True
- Application.CutCopyMode = False
- ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=ThisWorkbook.Path & "\" & ThisWorkbook.Name
- End Sub
½Æ»s¥N½X |
|