- ©«¤l
- 20
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 76
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- sp1
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-2-3
- ³Ì«áµn¿ý
- 2023-12-8
|
¸ó¤u§@ªí¿z¿ï
¥»©«³Ì«á¥Ñ hungrn ©ó 2020-5-20 13:17 ½s¿è
¦U¦ì¥ý¶i¦n
¤u§@ªí¤@ªº¸ê®Æn¿z¿ï¦Ü¤u§@ªí¤G...¦pªG¥Î¥H¤Urange«ü©w½d³ò¤è¦¡¥i¥H
Sheets("sheet1").Range("A1:H250").Sheets("sheet1").Range("A1:H250").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Range("A1:H1"), Unique:=False
¦]¬°¤u§@ªí¤@ªº¤º®e·|ÀHµÛ¸ê®Æªº¼W´î¦Ó§ïÅÜ row ,©Ò¥H·Q¥Î cells ¤è¦¡«ü©w½d³ò..¦ý·|Åã¥Üª«¥ó©w¸q¿ù»~..¬OAdvancedFilter ¤£¯à¥Îcells ÁÙ¬O?
Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Range(Cells(1, 1), Cells(1, 8)), Unique:=False
³Â·Ð¦U¦ì¥ý¶i«ü¾É..·PÁ |
|