- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 15
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-12
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2020-5-21 00:46 ½s¿è
Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRang ...
hungrn µoªí©ó 2020-5-20 14:19
§ï¦¨³o¼Ë¤]¥i¥H :
Sheets("sheet1").Range(Cells(1, 1), Cells(250, 8)).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("sheet1").Range("U1:U2"), _
CopyToRange:=Sheets("sheet2").Range(Sheets("sheet2").Cells(1, 1), Sheets("sheet2").Cells(1, 8)), Unique:=False
°ÝÃDÃöÁäÀ³¬O¥ÎCells§Î¦¡¨Óªí¥Ü "½d³ò" n¦U§O¸Ô²Ó«ü©w¦Ó¤£¬Oµ¹°Ñ¦Ò¦ì§}(¥uµ¹ Cells(1,1) ³oºØ, «e±¨S¦³§i¶D¥¦©ñ¦bþÓ Sheet),
¦Ü©ó Sheets("sheet1").Range("A1:H1") ³oºØªí¥Ü§Î¦¡,¥»¨´N¤w¤º§t«e«á³£¥Î³oÓSheet¤F,
§Aªº¤è¦¡¬OÓ§¹¾ãªºÀx¦s®æªí¥Ü¤è¦¡(Sheet.Range). |
|