¦p¦ó±qAÀɮפ¤¿ï¨ú¿z¿ï½d³ò¸ê®Æ«á¦A½Æ»sBÀɮפ¤?
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 8
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- Win2000
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-5-23
- ³Ì«áµn¿ý
- 2013-8-13
|
¦p¦ó±qAÀɮפ¤¿ï¨ú¿z¿ï½d³ò¸ê®Æ«á¦A½Æ»sBÀɮפ¤?
½Ð±Ð¦U¦ì°ª¤â&¤j¤j;
·s¤â¹J¨ì¤@Ó°ÝÃD¡AÀµ½Ð¸Ñ´b¡Cthanks~
-->¦p¦ó±qAÀɮפ¤¿ï¨ú¿z¿ï½d³ò¸ê®Æ«á¦A½Æ»sBÀɮפ¤?
¦p¹Ï©Ò¥Ü¡C |
|
|
|
|
|
|
- ©«¤l
- 23
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 51
- ÂI¦W
- 0
- §@·~¨t²Î
- WIn7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-30
- ³Ì«áµn¿ý
- 2013-7-10
|
¦^´_ 1# ckl520
¥H¤U½d¨Ò±N²Ä¤@Ó¤u§@ªíªº¿z¿ï¤º®e½Æ»s¨ì²Ä¤GÓ¤u§@ªí
¥i¥H¨Ì»Ý¨D¦Û¦æ½Õ¾ã- Sub Test()
- '½Æ»s«e¥ý±N¥Øªº¤u§@ªí²MªÅ
- Sheets(2).UsedRange.Clear
- '±q¨Ó·½¤u§@ªí½Æ»s¥i¨£ªºÀx¦s®æ¨ì¥Øªº¤u§@ªí
- Sheets(1).UsedRange.SpecialCells(xlCellTypeVisible).Copy _
- Destination:=Sheets(2).Range("A1")
- End Sub
½Æ»s¥N½X |
|
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 1# ckl520
³]A.XLS»PB.XLS§¡¤w¶}±Ò
A.XLS¤§¤@¯ë¼Ò²Õµ{¦¡½X- Sub XX()
- With Workbooks("A.XLS").Sheets("Sheet1")
- R1 = Application.Match("P/N", .[A:A], 0)
- R2 = Application.Match("Note", .[A:A], 0)
- Workbooks("B.XLS").Sheets("Sheet1").[A1].CurrentRegion = ""
- .Rows(R1 + 1 & ":" & R2 - 1).Copy Workbooks("B.XLS").Sheets("Sheet1").[A1]
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 8
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- Win2000
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-5-23
- ³Ì«áµn¿ý
- 2013-8-13
|
·PÁ¤W±¨â¦ì°ª¤â¥X¤â...
°ÝÃD¤w¸Ñ¨M!!
·P®¦
thanks~ |
|
|
|
|
|
|