- ©«¤l
- 42
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 283
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS XP
- ³nÅ骩¥»
- SP2
- ¾\ŪÅv
- 20
- ¨Ó¦Û
- KAOHSIUNG
- µù¥U®É¶¡
- 2010-5-8
- ³Ì«áµn¿ý
- 2024-8-13
|
¸Õ¸Õ¬Ý¥i¤£¥i¥H- bookname = ActiveWorkbook.Name
- J = Workbooks(bookname).Worksheets("¥þ").[D65536].End(xlUp).Row
- Worksheets("ì©l¸ê®Æ").[A:A].Find("¦a§}").Activate
- Selection.Copy
- Workbooks(bookname).Worksheets("¥þ").Range("D" & J + 1).PasteSpecial Paste:=xlPasteValues
- Application.CutCopyMode = False
½Æ»s¥N½X |
|