¦p¦ó§â¤u§@ªí1¸ê®Æ¿é¤J¤u§@ªí2
- ©«¤l
- 250
- ¥DÃD
- 59
- ºëµØ
- 0
- ¿n¤À
- 313
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¿Dªù
- µù¥U®É¶¡
- 2010-9-11
- ³Ì«áµn¿ý
- 2020-1-6
|
¦p¦ó§â¤u§@ªí1¸ê®Æ¿é¤J¤u§@ªí2
¥»©«³Ì«á¥Ñ ©P¤j°¶ ©ó 2013-10-8 19:16 ½s¿è
¤j¤jÌ, ½Ð±Ð¤@Ó¿é¤J°ÝÃD, ¨C¤Ñ³£¥²¶·¦b¤u§@ªí1¶À¦â°Ï°ì¶ñ¼g¸ê®ÆµM«á§â¸ê®Æ¿é¤J¤u§@ªí2¶Àªº¦â°Ï°ì¤º, ¦Ó¨C¦¸¿é¤J¤u§@ªí2³£©µÄò©¹¤U,
¦Ó²{®É³Ì¤jªº°ÝÃD¬O¤u§@ªí1¸ê®Æ°Ï¬O¦³¦X¨ÖÄæ¦ì, ¦bµ{¦¡¤W¬O§_¥i¥H°µ¨ì¤Wzn¨D.
|
|
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¥»©«³Ì«á¥Ñ owen06 ©ó 2013-10-9 09:29 ½s¿è
¦^´_ 1# ©P¤j°¶
¸Õ¸Õ¬Ý~- Sub test()
- Sheet1.Range("d15:" & [k65536].End(xlUp).Address(0, 0)).Copy
- Sheet2.Select
- Sheet2.[a65536].End(xlUp).Range("a2").Select
- ActiveSheet.Paste
- Columns("d").Hidden = True
- Sheet2.[a65536].End(xlUp).Select
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¤£¦n·N«ä¡A¸É¥R¤@¤U¡A
Columns("d").Hidden = True n§ï¦¨
sheet2.Columns("d").Hidden = True
³o¼Ë¤~¤£·|§âªí¤@ªºdÄæ¤]ÁôÂñ¼ |
|
|
|
|
|
|
- ©«¤l
- 250
- ¥DÃD
- 59
- ºëµØ
- 0
- ¿n¤À
- 313
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¿Dªù
- µù¥U®É¶¡
- 2010-9-11
- ³Ì«áµn¿ý
- 2020-1-6
|
¥»©«³Ì«á¥Ñ ©P¤j°¶ ©ó 2013-10-9 10:54 ½s¿è
¦^´_ 3# owen06
¦ó¨Ó¤£¦n·N«ä, ±o¨ì¤j¤j̦^À³, ¦hÁÂÁÙ¨Ó¤£¤Î, ¯u¤ß·PÁÂ.... |
|
|
|
|
|
|