- ©«¤l
- 58
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 117
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2017-12-2
- ³Ì«áµn¿ý
- 2021-12-16
|
¥»©«³Ì«á¥Ñ wei9133 ©ó 2020-10-9 01:16 ½s¿è
¦^´_ 17# wei9133
§Ú§â§Ú¨ãÅ骺¾Þ§@¿ý¦¨¼v¤ù¤F¡A¬Ý¤@¤U©Î³\¯àÀ´?
https://sendvid.com/suu270r2
¨ä¤¤¾ãÄ檽±µ¿z¿ï¦¨V©ÎWªº³¡¤À¦]¬°§Ú¤w¸g¿ý¦¨¥¨¶°©Ò¥H¨S¦³¥h©Ô¤U©Ô¦¡¿ï³æ- Sub ¿z¿ï¬°V() '^U
- Dim i As Integer
- i = ActiveCell.Column 'Àò¨úÄæ¦ìÈ
- Cells(1, i).Select
- Selection.AutoFilter Field:=i, Criteria1:="V"
- '±N¸Ó®æ¿z¿ï¬°"V"
- End Sub
- Sub ¿z¿ï¬°W() '^I
- Dim i As Integer
- i = ActiveCell.Column 'Àò¨úÄæ¦ìÈ
- Cells(1, i).Select
- Selection.AutoFilter Field:=i, Criteria1:="W"
- '±N¸Ó®æ¿z¿ï¬°"W"
- End Sub
- Sub ¿z¿ï¬°ªÅ®æ() '^B
- Dim i As Integer
- i = ActiveCell.Column 'Àò¨úÄæ¦ìÈ
- Cells(1, i).Select
- Selection.AutoFilter Field:=i, Criteria1:="="
- '±N¸Ó®æ¿z¿ï¬°"ªÅ®æ"
- End Sub
- Sub ¿z¿ï¬°«DªÅ®æ() 'O
- Dim i As Integer
- i = ActiveCell.Column 'Àò¨úÄæ¦ìÈ
- Cells(1, i).Select
- Selection.AutoFilter Field:=i, Criteria1:="<>"
- '±N¸Ó®æ¿z¿ï¬°"«DªÅ®æ"
- End Sub
- Sub ¿z¿ï¬°¥þ¿ï() '^+Q
- Dim i As Integer
- i = ActiveCell.Column 'Àò¨úÄæ¦ìÈ
- Cells(1, i).Select
- Selection.AutoFilter Field:=i ' Criteria1:="<>" ¡A¬Ý°_¨Ó¨S¦³µ¹«á±³o¦ê«ü©wÈ´N¬O¥þ³¡¤F
- '±N¸Ó®æ¿z¿ï¬°"¥þ³¡"
- End Sub
½Æ»s¥N½X ¤@¶}©l§Ú»Ýnªº¥\¯à»Ý¨D¨ä¹ê¬O³oÓ
¦b§Ú¿ï§¹¬Y¤@Ã䤧«á¡A§â¥t¤@Ãä¥þ³¡¥Ñ¿z¿ï¤U©Ô¦¡¿ï³æ¿ï¦^"¥þ¿ï"
https://sendvid.com/3ifimegq
©Ò¥H¤~·|¥X²{³oºØªF¦è- sub ¿z¿ï«áºÝ ()
- Sub ¿z¿ï«áºÝ()
- Dim var_min, var_max, i, j, s As Integer
- var_min = 51 '«á¥b¬q°_
- var_max = 99 '«á¥b¬q¨´
- For j = var_min To var_max
- j = j + 1
- Cells(1, j).Select
- Selection.AutoFilter Field:=j
- Next j
- End Sub
½Æ»s¥N½X ¦ý¬O³o²Õ¥N½X¦n¹³¨S¥Î¡A©Ò¥H¤~·|¨Ó°Ý |
|