- ©«¤l
- 37
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- 0
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2020-7-23
- ³Ì«áµn¿ý
- 2022-5-27
|
¦U¦ì°ª¤â¡A¯uªººÉ¤O¤F~filter¤@ª½·d¤£©w¡A¥Î¥t¥~¤@ºØ¼gªk¡A¼g¨ì³o¸Ì¡A¤£ª¾¹D°ÝÃD¦bþ¡AµLªk±N¾ã¦C½Æ»s¨ì«ü©w¤u§@ªíªº³Ì«á¤@Äæ¡AÁÂÁ¦U¦ì°ª¤â- Sub °j°é1()
- All = Array("¤T°Ó", "»·ªF")
- For r = ActiveSheet.UsedRange.Rows.Count To 1 Step -1
-
- For i = 0 To UBound(All)
-
- If Cells(r, 2) = All(i) Then
- Rows(r).EntireRow.Copy
- Sheets(All).Select
- ActiveSheet.Paste
- Exit For
- End If
-
- Next
- Next
- End Sub
½Æ»s¥N½X |
|